AD 46-36-01
Registered aircraft · 9,759
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:46-36-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:46-36-01')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:46-36-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:46-36-01') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N1151ELuke Stanley W Jr · Rochester Hills, MIN1152ELeeds Stained Glass Co Inc · Leeds, ALN1153BHultzapple Ted D · Farmington, NYN1154AMorris John · Oconomowoc, WIN1154BTingle Ethan C · Fort Campbell, KYN1154ENewberry Richard A Sr · Springdale, ARN1160ESrt Aero · Pauls Valley, OKN1160KDenney Mark J Trustee · Battlefield, MON1161EViking Champ Club · Eleva, WIN1162BWilson Dyle B · Trenton, MOFirst renewal noticeN1162EBailey Carlton D Jr · Huntington, WVN1162KKruckeberg Leroy A · Sanford, NCN1164KGoode Stephen C · Canton, TXN1165BSpivey Kenneth R Jr · Vestavia, ALN1165SStark David M · Merkel, TXN1167EGabbert Tate · Sarasota, FLN1167KCowger Steven J · Harrisonburg, VAN116JKJetran LLC · Horseshoe Bay, TXN1170KDaw Brian W · Monmouth, ILN1171KWiebe James R · Valley Center, KSN1174KWoodburn Thomas J · Glen Allen, VAN1178EDills Timothy E DBA · Clymer, NYN1179BSchuyler Paul · Morgan Hill, CAN1179KGingerich Roger · Narvon, PAN1180KFlying Luscombe LLC · Okeechobee, FLN11818Ooi Lucy M · Catlett, VAN1184BNelson Fred L III · Brandon, MSN11850Freeman Heritage Collection LLC · Kingsbury, TXN1185BSmith William P · Chandler, OKN11878Pocock Vera Alvena · China Spring, TXN1187EEsterak David R · Boyce, LAN1188BVyfvinkel Frederick J · New Smyrna Beach, FLN118LMMason Lewis G · San Antonio, TXN118VRAlliance Aircraft Sales Inc · Pierre, SDN1190KBlack Widow Aviation LLC · Sahuarita, AZN11916Pleasure Air LLC · Lake Havasu City, AZN1191BMenees Terry J · Tempe, AZN1191ELawler Thomas O · Lava Hot Springs, IDN1192BDunshee Anette M · La Luz, NMN1193BBlackburn Richard L · Pendleton, ORN1194BMclaughlin John P · North Royalton, OHN1196ECofer Billie W · Double Oak, TXN1196KStrader Wayne G · Ardmore, OKN1197ECouch John Ainsley · Sealy, TXN1197KBrandt Judson C · Greenville, GAN1198KKulle William T · Springfield, MAN119CGGreeley Barton M Jr · Coudersport, PAN11CJJackson William A Jr · Hillsboro, ORN11EPWingnut Inc · Wilmington, DEN11PVJones Richard · Azalea, OR
Back to AD 46-36-01