Skip to content

Registered aircraft · 54,015

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

N6349GKuhns Mathew M · Saranac, MIBuilt 1970 · S/N 15071849 N6349JH & H Aviation Enterprises LLC · Fairfield, OHBuilt 1980 · S/N 17273866 N6349KRoybal Michael A · Freeport, FLBuilt 1975 · S/N 15077658 N6349MTakai Hiroyasu · San Jose, CABuilt 1980 · S/N 15284688 N6349SMazzarese Nicholas · Cedar Hills, UTS/N 15067149 N634AHyatt Alex K · Locust Grove, GABuilt 1960 · S/N 634 N634EHEd-Air Inc · Oaktown, INBuilt 1971 · S/N A1500315 N634NCN634nc LLC · Apopka, FLBuilt 1977 · S/N 18266008 N634WGWings Of Grace Ministries Inc · Melbourne, FLFirst renewal noticeBuilt 1965 · S/N 17252781 N63500Johnson Lawrence F · Anchorage, AKBuilt 1975 · S/N 15077349 N63501Walters Daniel B · Hillsboro, MOBuilt 1975 · S/N 15077350 N63504Callahan Mfg Inc · Royal City, WABuilt 1975 · S/N 15077353 N63507Scudder Waylon B · Winona, MOBuilt 1975 · S/N 15077356 N63508New Joel H · Waco, TXBuilt 1975 · S/N 15077357 N6350BLefeve Douglas H · Cedar Park, TXBuilt 1957 · S/N 34250 N6350DMazza Salvatore M · West Creek, NJBuilt 1979 · S/N 17272736 N6350EAirport Bums Aero Club · Branson, MOBuilt 1959 · S/N 46450 N6350GZimny Daniel M · Rancho Cordova, CAS/N 15071850 N6350MAirplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1980 · S/N 15284689 N6350QDavis Joseph T · Lunenburg, MABuilt 1981 · S/N 15285234 N6350TDallob Seth · Reno, NVS/N R18201991 N63512New England Aviation LLC · Plainville, CTBuilt 1981 · S/N 17275447 N63515Rivera Jaime · San Antonio, TXS/N 15077363 N6351EMaluda Erick · Enigma, GABuilt 1959 · S/N 46451 N6351GWhirling Wings LLC · Lexington, NCBuilt 1970 · S/N 15071851 N6351PAirplanes And Helicopters Of Oregon LLC · Sisters, ORS/N 15285006 N63524New Garden Township · Landenberg, PABuilt 1975 · S/N 15077371 N63525Mickler Andrew E · Wasilla, AKBuilt 1977 · S/N 18052852 N63526Pollard Charles A · Eau Claire, WIBuilt 1975 · S/N 15077373 N6352ERotter Dale H · Colville, WABuilt 1959 · S/N 46452 N6352FFletcher John G · Diamondhead, MSS/N 337-0352 N6352GJohnson Jeffrey L · Paradise, CABuilt 1970 · S/N 15071852 N6352VMiles Richard A · Macon, NCBuilt 1980 · S/N 172RG0640 N6352ZSale Reported · Anchorage, AKSale reportedBuilt 1981 · S/N U20606250 N63532Seniram Air Inc · Wilmington, DEBuilt 1975 · S/N 15077377 N63533Rue Levi G · Sheyenne, NDBuilt 1975 · S/N 15077378 N63534Gaudet Edward · Winthrop, MES/N 18052853 N6353ACypress Soaring Inc · Hemet, CABuilt 1956 · S/N 33153 N6353DDeland Aviation LLC · Deland, FLBuilt 1979 · S/N 17272739 N6353UBas Part Sales LLC · Greeley, COBuilt 1985 · S/N 21064941 N63543Turner Jeffrey L · Sour Lake, TXBuilt 1975 · S/N 15077382 N63547Puppy Dog Aviation LLC · Anchorage, AKBuilt 1975 · S/N 15077386 N63548Hoyle Jason · Grove, OKBuilt 1975 · S/N 15077387 N6354BSgc Soaring Foundation · Bellevue, WABuilt 1957 · S/N 34254 N6354KAvenge Holdings LLC · Ashburn, VABuilt 1975 · S/N 15077660 N63550Reid Edwin T · Lake Charles, LABuilt 1975 · S/N 15077388 N63554Nuovo LLC · Portland, ORBuilt 1977 · S/N 18052854 N63556Tietje Barry N · Elton, LABuilt 1975 · S/N 15077393 N6355BRich Lucas Aircraft Sales LLC · Lincoln Park, NJS/N 34255 N6355CDutch Air LLC · Kalispell, MTBuilt 1980 · S/N 21063874

Back to AD 87-20-03 R2