Skip to content

Registered aircraft · 20,481

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.

N52852Hultin Ronald · Rosemount, MNBuilt 1974 · S/N 18262897 N52853Heintz David A · Culver, ORS/N 18262898 N52857Tdex Equipment · Abilene, TXBuilt 1974 · S/N 18262901 N52859Wehrs Aviation LLC · Johnsburg, ILBuilt 1974 · S/N 18262903 N5285DBarker Aviation LLC · Ardmore, OKBuilt 1958 · S/N 50183 N5285UShroyer Jayme D · Longmont, COBuilt 1964 · S/N U206-0285 N52861Holst Thomas C · Pleasant Hope, MOBuilt 1974 · S/N 18262904 N52863Swodeck John · Gilbert, AZS/N 18262906 N52866Egan Bailey J · Forsyth, MTBuilt 1974 · S/N 18262909 N5286TWilson Aviation LLC · Robinson, ILBuilt 1984 · S/N R18201849 N52873Pepper Daniel J · Henderson, TXBuilt 1974 · S/N 18262916 N52876Noteboom Mike · Orange City, IABuilt 1974 · S/N 18262918 N5287ATax Busters Inc · El Paso, TXBuilt 1979 · S/N 21063349 N5287DWitham Kyle S · Lakeview, ORBuilt 1958 · S/N 50185 N5287YMorrow Aviation LLC · Midland, TXS/N 21064152 N52880Matta Sam · Houston, TXBuilt 1974 · S/N 18262921 N52884Smith Eric Von Trustee · Vallejo, CAFirst renewal noticeBuilt 1974 · S/N 18262925 N52886Gilbert Jack M · Visalia, CABuilt 1974 · S/N 18262927 N52888Alphadelta Aviation LLC · East Windsor, CTS/N 18262928 N52895Marshall Brian L · Hays, KSS/N 18262933 N52899Kalogerson George G Trustee · Eden Prairie, MNBuilt 1974 · S/N 18262937 N528CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 18283032 N528ESBraner Dana A · Portland, ORBuilt 1979 · S/N 18267328 N528KCBukhart Don · Blakely Island, WABuilt 2002 · S/N 18281109 N528LDCar Two Charlie LLC · Lewes, DEBuilt 2021 · S/N 18283130 N528LEZeus Aviation LLC · Carlisle, OHBuilt 2008 · S/N 18282046 N528MJAircraft Owners & Pilots Association · Frederick, MDBuilt 2001 · S/N 18280991 N528PVMelin Mark Alan · Newport, NCBuilt 2007 · S/N 18282035 N52907Hatcher James A · Hilltop Lakes, TXBuilt 1974 · S/N 18262943 N52916Boston Center Flying Club Inc · Dracut, MABuilt 1974 · S/N 18262949 N52919Tucker Benny L · Thomaston, GABuilt 1974 · S/N 18262952 N5291DJacobson Anthony P · Wasilla, AKBuilt 1958 · S/N 50189 N5291NJdb Aviation LLC · Topeka, KSBuilt 1980 · S/N 18267623 N5291TGodin David M · Levant, MEBuilt 1959 · S/N 50553 N52923Grinton Harry M · Arvada, COBuilt 1974 · S/N 18262955 N5292NGoicoechea Mitchell Trustee · Elko, NVBuilt 1980 · S/N 18267624 N5293XBaker Leasing LLC · Kotzebue, AKS/N U20605612 N52940Schickner Michael J · Mesa, AZBuilt 1974 · S/N 18262964 N52942Origer Deborah F · Albany, ORS/N 18262966 N52957Koch Eric C · Charlotte, NCBuilt 1974 · S/N 18262973 N52959Triple T Metal Corp · Bryantsville, KYBuilt 1974 · S/N 18262975 N5295NHillcrest Emergency Physicans Inc · Tulsa, OKBuilt 1980 · S/N 18267627 N52963Union Movie Works LLC · Sacramento, CABuilt 1974 · S/N 18262976 N5296UMeyers Karl F · Tucson, AZRegistration revokedBuilt 1964 · S/N U206-0296 N52981J-Bear Aviation LLC · Whitefish, MTBuilt 1974 · S/N 18262984 N52983Cabaud John P · Oroville, CABuilt 1974 · S/N 18262986 N52989Southwest Tailwinds LLC · Camarillo, CABuilt 1974 · S/N 18262989 N5298EDunlap Russell M · Palmer, AKBuilt 1959 · S/N 50598 N5298UPatanapong Somboonsap · Oakland Park, FLBuilt 1964 · S/N U2060298 N52992Registered aircraftBuilt 1974 · S/N 18262991

Back to AD 84-10-01 R1