Skip to content

Registered aircraft · 20,483

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:84-10-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:84-10-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:84-10-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:84-10-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:84-10-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:84-10-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.

N3024YTemple Curtis Lee · Porcupine, SDBuilt 1962 · S/N 18254024 N3025FWarner Daniel M · Fremont, OHBuilt 1966 · S/N 18257125 N30268Rudd Terry R · Clarkston, WABuilt 1973 · S/N 21059903 N3026BMacario T Michael · Townsend, DEBuilt 1952 · S/N 7909 N3026FMock1 LLC · Abingdon, VABuilt 1966 · S/N 18257126 N3026QSuper D Group LLC · Hanoverton, OHBuilt 1967 · S/N 18258026 N3026YEpss LLC · Tavernier, FLBuilt 1962 · S/N 18254026 N3027BLacey William F · Parker, COBuilt 1952 · S/N 7910 N3027FSale Reported · Watford City, NDSale reported, pending cancellationBuilt 1966 · S/N 18257127 N30280Emery Clint L · Texarkana, ARBuilt 1973 · S/N 21059907 N3028QAllenspach Timothy L · Stillwater, MNBuilt 1967 · S/N 18258028 N3028YStanton Tod J · Naperville, ILBuilt 1962 · S/N 18254028 N3029BWilson Christopher W · Edgewood, NMBuilt 1952 · S/N 7912 N3029QOzarks Auto Show Inc · Hollister, MOBuilt 1967 · S/N 18258029 N302AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281190 N302GPInternational Air Services Inc Trustee · Carson City, NVS/N 21058682 N302MPKqm Aviation · Bristow, VABuilt 2010 · S/N 18282273 N302STManagement Support Services LLC · Naturita, COBuilt 1968 · S/N T210-0350 N302USolomon Mark Trustee · Wilmington, DEBuilt 1964 · S/N 18255529 N3030FThirty Thirty Club · Lebanon, ORBuilt 1966 · S/N 18257130 N3030YSamaniego Alejandro · Tucson, AZBuilt 1962 · S/N 18254030 N3031BPontieri Kari · Parma, OHBuilt 1952 · S/N 7914 N3031FAlderson John M · Venice, CABuilt 1966 · S/N 18257131 N3031YAir Repair Inc · Cleveland, MSBuilt 1962 · S/N 18254031 N3032BHendrix Todd M · Bakersfield, CABuilt 1952 · S/N 7915 N3032QMitchell Michael A · Old Forge, NYBuilt 1967 · S/N 18258032 N3033LDaniel Gary · Fallston, MDBuilt 2008 · S/N 18282109 N3033QFisher David E DBA · Bristow, OKBuilt 1967 · S/N 18258033 N3035BFlying W Aviation Enterprises · Bellevue, NEBuilt 1952 · S/N 7918 N3035YWardlaw Consulting LLC · Truckee, CABuilt 1962 · S/N 18254035 N3036Q3 Rivers Airshare Llp · Sheridan, MTBuilt 1967 · S/N 18258036 N3036YPeterson Zachary E · Fargo, NDBuilt 1962 · S/N 18254036 N30374Canihan William R · Novato, CABuilt 1973 · S/N 21059918 N3037BQualitair LLC Trustee · MichelstadtBuilt 1952 · S/N 7920 N3037QState Of Arizona · Holbrook, AZBuilt 1967 · S/N 18258037 N3038FTaylor Spencer H · Lake City, FLBuilt 1966 · S/N 18257138 N303BSLegacy Restoration Services Inc · Cumming, GABuilt 1980 · S/N 182-67622 N303CTFloyd Brian · Eatonton, GABuilt 1978 · S/N 21062591 N303SDHarris County Sheriff'S Office · Spring, TXBuilt 1973 · S/N 18261849 N303XStocki Ronald W · Centennial, COBuilt 1960 · S/N 52957 N3040FJump Tn LLC · Greeneville, TNBuilt 1966 · S/N 18257140 N3040YRight Rudder Flyers LLC · Columbia Falls, MTS/N 18254040 N3041FRoffey Edward P Trustee · Grand Junction, COBuilt 1966 · S/N 18257141 N3042BDiaz Carlos Ricardo · Pensacola, FLBuilt 1952 · S/N 7925 N3042FTdc Aviation LLC · Scottsdale, AZBuilt 1966 · S/N 18257142 N3043QDerango Gregory J · Chitina, AKBuilt 1967 · S/N 18258043 N30444Crapnell Mark · Huntington Beach, CAS/N 210-58861 N3044QParrow Ronald J · Hampton, CTBuilt 1967 · S/N 18258044 N30453Lehman Land Management LLC · Vernon, TXBuilt 1973 · S/N 21059923 N3045BSmokovitz Joseph M · Tecumseh, MIBuilt 1994 · S/N 7928

Back to AD 84-10-01 R1