Skip to content

Registered aircraft · 71

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

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:2016-08-19') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-08-19') ORDER BY n_number

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:2016-08-19')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-08-19')
  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:2016-08-19')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-08-19')
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.

N100BYFirst Flight Aviation LLC · Boerne, TXBuilt 1984 · S/N 1565 S.A.N100MUWakaya Services Inc · Dover, DEBuilt 1980 · S/N 793SA N1164FRegistration Pending · Dickerson, MDRegistration pendingS/N 1562 S.A.N117HGobuyair LLC · Flint, MIBuilt 1979 · S/N 751SA N129DWDelta Whiskey Ltd · Staten Island, NYBuilt 1974 · S/N 653 N130MS3b Leasing LLC · Fairhope, ALS/N 750SA N13YSAir 1st Aviation Companies Inc · Aiken, SCBuilt 1976 · S/N 694 N14VLJpw Aviation LLC · Clarksdale, MSBuilt 1981 · S/N 1514SA N15TCStax Holdings LLC · Hot Springs, ARBuilt 1976 · S/N 692 N1727SN1727s LLC · Calhoun, GAS/N 1504 S.A.N175CAAir 1st Aviation Companies Of Oklahoma Inc · Tulsa, OKBuilt 1979 · S/N 736SA N17HGMu2 LLC · Lewes, DEBuilt 1981 · S/N 1510 S.A.N193AABig Mountain Aviation Inc · Whitefish, MTBuilt 1979 · S/N 741SA N196MAStef Air LLC · Muscle Shoals, ALBuilt 1979 · S/N 764 S.A.N220JSMt Mgt LLC · Missoula, MTBuilt 1981 · S/N 1545 S.A.N222FAExpress Aviation Management LLC · Dover, DES/N 714SA N24WCDach Capital Holdings Inc · Newark, DES/N 705SA N271TWBaker Aviation LLC · Dover, DES/N 734 S.A.N321GMWestern News & Info Inc · Prescott Valley, AZBuilt 1981 · S/N 1505 SA N32ECAlan H Brodine Dmd Pc · Rochester, NYBuilt 1977 · S/N 699SA N338MLJdm Aviation LLC · Marceline, MOBuilt 1981 · S/N 1539SA N33EWAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1981 · S/N 1519 S.A.N350RGAdams Michael D · Mckinney, TXBuilt 1980 · S/N 773 S.A.N360RAMillennium Flight Leasing Inc · Wilmington, DES/N 740SA N3MAAir 1st Aviation Compainies Inc · Aiken, SCS/N 1511 S.A.N423DB2945l LLC · Terrell, TXS/N 1543 S.A.N42AFWild Hare Enterprises LLC · Valparaiso, INBuilt 1980 · S/N 787 S.A.N444WFZadeh Aviation Group LLC · El Centro, CAS/N 1551 S.A.N44AFTrinity Group · Watford City, NDBuilt 1981 · S/N 790SA N44MXRiver City Aviation Inc · Fairdealing, MOBuilt 1981 · S/N 1526 S.A.N466DCAerotel Inc · Spring Hill, FLBuilt 1981 · S/N 1528SA N467MAAlc Aviation LLC · Cheyenne, WYS/N 1567SA N46AKExpress Aviation Management LLC · Dover, DEBuilt 1979 · S/N 754S.A.N4RRough Ryder Aircraft Inc · Carmel, NYBuilt 1981 · S/N 1542 S.A.N500PJFly2mellc · Ooltewah, TNBuilt 1974 · S/N 668 N511AMRegistered aircraftBuilt 1982 · S/N 1556 S.A.N513DMWeissenburger Aviation Inc · Wilmington, DEBuilt 1982 · S/N 1560 S.A.N59KSOconnell Meares Investments Ltd · Tampa, FLBuilt 1974 · S/N 664 N601SDJefferson County Sheriffs Office · Beaumont, TXBuilt 1973 · S/N 610 N60KCRegistered aircraftS/N 781 S.A.N60TEAerostar Holdings LLC · Kalispell, MTS/N 1515SA N61BAUnlimited Boat Sales Inc · Page, AZBuilt 1978 · S/N 729SA N621TAAustin Bill DBA · Sparta, TNS/N 605 N644EMAgrilogics Industries LLC · Dalhart, TXBuilt 1980 · S/N 758SA N661DPMaricopa Helicopter LLC · Fresno, CAS/N 798 S.A.N687HBSouthern Jets Inc · Naples, FLS/N 687 N6KECosco & Associates Inc DBA · Crestview, FLS/N 766 S.A.N718EEN718ee LLC · Missoula, MTBuilt 1978 · S/N 718SA N727TPAudubon Air Of Louisiana LLC · Bossier City, LABuilt 1981 · S/N 1517SA N741FNAir 1st Aviation Co Of Ok · Tulsa, OKBuilt 1975 · S/N 658

Back to AD 2016-08-19