AD 74-19-01
Registered aircraft · 2,673
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:74-19-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:74-19-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:74-19-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:74-19-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.
N122TEBouchillon James R · Hanahan, SCN1230TWings Over Texas Holdings LLC · Denton, TXN1239TPhoenix East Aviation LLC · Daytona Beach, FLN123BEBald Moutain Aviators · Fredericktown, MON123LUSutton Aircraft Salvage LLC · Palmer, AKN123MFAronhalt Daniel E · Columbus, INN123TXGofly Corporation · Port Ewen, NYN123YAAircraft Guaranty Corp Trustee · Oklahoma City, OKN1246TRegistration Pending · Fort Mc Coy, FLRegistration pendingN125FLAll Star Capital LLC · Concord, NCN1287TBelle Casa Aero LLC · Tarpon Springs, FLN128AGarza Family LLC · Helena, MTN128WPPatterson Weldon E · Maryville, TNN1293TN1293t LLC · Wilmington, DEN1297HHop A Chopper Inc · Dover, DEN1297TReich David W · Fort Lauderdale, FLN129SCSouthern Aircraft Consultancy Inc Trustee · Casper, WYN130BWPobiega Michael J · Fort Mill, SCN130GHBose Tamal · Tucson, AZN1327TCedel Solutions LLC · Austin, TXN132KMKing General Contractors Inc · Bristol, VAN132LESouthern Aircraft Consultancy Inc Trustee · Casper, WYN133PTKittle David · Siloam Springs, ARN1343TWestern Cherokee Six LLC · Fort Collins, CON134ACSkyline Solutions Inc · Deland, FLN1355TRmf Trucking LLC · Tuscaloosa, ALN1369TWings Over Texas Holdings LLC · Denton, TXN1380TN1380t LLC · Wilmington, DEN1390TAccessible Aviation Inc · Tupelo, MSN1391TAbita Air LLC · Covington, LAN13RGIsland Piper Llp · St Helena Is, SCN1407TAndrews University · Berrien Springs, MIN1409XHolmberg Shane A · Fairbanks, AKN140JGBarros Vincent · Kissimmee, FLN1419XWhitman Aviation LLC · Morganville, NJN141ANWells Ryan · Holdrege, NEN1421TBurr Charles R Jr · Palm Bay, FLN1424MFly High LLC · Mobile, ALN14258Bayshore Aviation LLC · Saint Petersburg, FLN1426THillcrest Of Central Fl LLC · Auburndale, FLN1435TWaters Nicholas T · Claypool, INN1436TDeland Aviation LLC · Deland, FLN143DWCardinal Aviation LLC · Towson, MDN1450XHopkins David M · Bell Buckle, TNN1452TAbacus Automation · Bennington, VTN1465HHolland Ray A · Blue Earth, MNN1465TCaudle Tommie A · Bentonville, ARN146MBMlc Flying Club LLC · Saint Peters, MON146SCFantasy Aire Inc · Wilmington, DEN1474TStella Stephen G DBA · Fort Lauderdale, FL
Back to AD 74-19-01