Skip to content

Registered aircraft · 5,086

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

N9034PNational Test Pilot School · Mojave, CABuilt 1966 · S/N 24-4496 N9037PJack Ryan Aviation · Woodcliff Lake, NJS/N 24-4500 N9042PWt Del Pl LLC · Newark, DEBuilt 1966 · S/N 24-4505 N904JDTd Ventures Inc · Las Vegas, NVBuilt 2000 · S/N T20608195 N904SCMedical Disposables Corp · Orlando, FLBuilt 1981 · S/N 31-8152194 N90509Mccollum Timothy L · Toccoa, GABuilt 1976 · S/N 60-0297-111 N9050PFrisbee Robert P · Mcminnville, ORBuilt 1966 · S/N 24-4515 N9052PVentura Alejandro · Lakeside, CABuilt 1966 · S/N 24-4518 N9053POhlstein Michael R · Glen Head, NYBuilt 1966 · S/N 24-4519 N9055PB Dot Air LLC · Jackson, WYBuilt 1966 · S/N 24-4521 N9056PMarion Brian R · Denver City, TXBuilt 1966 · S/N 24-4522 N9057PLambert Dwight E · Albany, ORBuilt 1966 · S/N 24-4523 N905DSHouser Theodocia Z · San Angelo, TXBuilt 2001 · S/N 3257236 N905TJWhittington Peter M · Jupiter, FLS/N 31-7952204 N90608Hacker Henry · Mc Gregor, TXBuilt 1976 · S/N 61P-0318-087 N9061PLangley Preston B · Warwick, NDBuilt 1966 · S/N 24-4528 N9063PDavis Clyde Jackson Jr Trustee · Tehachapi, CABuilt 1966 · S/N 24-4530 N9065POdenbach Eric J · Eureka, SDBuilt 1966 · S/N 24-4533 N90679Kansas City Aviation Center Inc · Olathe, KSBuilt 1976 · S/N 61-0357-115 N9067PMahathey Tony C · Colorado Springs, COBuilt 1966 · S/N 24-4535 N9069PGeer James Benjamin · Olympia, WABuilt 1966 · S/N 24-4537 N9069YAmi Aviation Inc · Monroe, NYBuilt 1967 · S/N 31-99 N906DGExpensive Hobby LLC · Whitehouse Station, NJBuilt 2005 · S/N T18208468 N9070PWilliamson Paul H · Carrollton, TXS/N 24-4538 N9074PNickell Jon B · North Platte, NEBuilt 1966 · S/N 24-4543 N9075PKovacevich Nicholas P · Jackson, CABuilt 1966 · S/N 24-4544 N9077PFarris James E · Brentwood, TNFirst renewal noticeBuilt 1966 · S/N 24-4546 N9079PTyrrel David E · Harlan, IABuilt 1966 · S/N 24-4549 N907WDWd Aircraft Investments LLC · Anchorage, AKBuilt 2000 · S/N T20608230 N9080NBoeing Co · Renton, WABuilt 1969 · S/N 3066 N9081PTriple J Aviation LLC · Turlock, CABuilt 1966 · S/N 24-4551 N9082PAmeneyro David · Walla Walla, WABuilt 1966 · S/N 24-4552 N9083PRowland Blayne Administrator · Raymondville, TXBuilt 1966 · S/N 24-4553 N9084PSchafer Timothy M · Ridgefield, CTBuilt 1966 · S/N 24-4555 N9085PCross Seth B · Whitewood, SDS/N 24-4556 N9086PRick Crum Aircraft Sales Inc · Prestonsburg, KYBuilt 1966 · S/N 24-4557 N9089PDummer Donald W · Novato, CABuilt 1966 · S/N 24-4563 N908DKNeilson Frank · Orlando, FLBuilt 1973 · S/N 32-7440070 N908MABlue Air Venture LLC · Gilcrest, COS/N T20608093 N9090PCatherwood Owen · Eugene, ORBuilt 1966 · S/N 24-4564 N9091PGalagan Robert · Lincoln Park, NJBuilt 1966 · S/N 24-4565 N9095YAviation Trust Company LLC · Oklahoma City, OKS/N 32R-8529008 N9096NStones River Aviation LLC · Murfreesboro, TNBuilt 1969 · S/N 3076 N9096PGoodman Kenneth M · Eastpoint, FLBuilt 1966 · S/N 24-4572 N90977Mouse Air LLC · Hilton Head Island, SCBuilt 1981 · S/N 32R-8129048 N9097PA T Aviation LLC · Cherokee, IABuilt 1966 · S/N 24-4573 N90BWSalter Scott A · Moscow, TNBuilt 1981 · S/N 32R-8129006 N90EFBardoo Sean L · Massapequa, NYBuilt 1976 · S/N 27-7654081 N90ERSkyes Aviation Outfitters LLC · Laguna Vista, TXBuilt 1999 · S/N 4636243 N90JPAec Shrike LLC · Barrington, ILBuilt 1970 · S/N 3078

Back to AD 91-21-01 R1