Skip to content

Registered aircraft · 54,019

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.

N19476Havron Dana Houston · Huntsville, ALS/N 15074438 N19477Rare Birds LLC · Yukon, OKBuilt 1973 · S/N 15074439 N19479Kunkle Bryan S · Mount Morris, NYBuilt 1973 · S/N 15074441 N1947CWillingham Emma J · Grantville, GABuilt 1953 · S/N 26092 N1947FMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17273037 N1947QBailey Jr James E · Rittman, OHBuilt 1973 · S/N 177RG0347 N19480Blair Mark · Kingman, AZBuilt 1973 · S/N 15074442 N19481Majors Flying Club · Greenville, TXBuilt 1973 · S/N 15074443 N19486Beavers David Allen · Strasburg, COS/N 15074444 N1948BKc Aviation LLC · Conway, ARBuilt 1974 · S/N 177RG0564 N1948FKdrd Holdings LLC · Texas City, TXBuilt 1979 · S/N 17273038 N1948QHorsley Luther J · Midland, ORS/N 177RG0348 N1948XGreenwood Auto LLC · Itta Bena, MSBuilt 1965 · S/N 18256048 N194961w1 Aero LLC · Issaquah, WABuilt 1973 · S/N 15074450 N1949CBailey John Perry · Eagle River, AKS/N 26094 N1949PEast Bay Trading Co LLC · Fairview, PABuilt 1973 · S/N 17262835 N194ARTarpley Richard · Cleveland, GABuilt 1978 · S/N 17272029 N194SESamnik Enterprises LLC · Naples, MEBuilt 1972 · S/N 17260386 N19501Beardsley Larry N · Leavittsburg, OHBuilt 1976 · S/N 17702574 N19506Colvard Tony D · Newland, NCS/N 15074457 N19508Andelt David L · Parker, COBuilt 1973 · S/N 15074459 N1950CTupelo Aeronautics Inc · Tupelo, MSBuilt 1954 · S/N 16183 N1950FAce Of Spades Aviation LLC · Las Vegas, NVS/N 17273040 N1950QSherwood Jeffrey Curtis · Cranston, RIBuilt 1973 · S/N 177RG0350 N1950U3 Stones Productions LLC · Anchorage, AKBuilt 1970 · S/N 18501659 N1950VJenson Kenneth E · Modesto, CABuilt 1980 · S/N 182-67632 N1950ZStafford Branson T · Maple Hill, NCS/N 15059750 N19514N&C Enterprises LLC · Vine Grove, KYS/N 15074461 N19516Choppin Dale · Sun City, AZBuilt 1973 · S/N 15074462 N19519Gulf Niner LLC · Eagan, MNBuilt 1976 · S/N 17702575 N1951TBachmann Jochen W · Hudson, OHBuilt 1980 · S/N 185-04134 N1951XSkyline Aircraft Maintenance Inc · Nampa, IDBuilt 1965 · S/N 18256051 N1951ZAnderson Zachery D · Bigfork, MTBuilt 1962 · S/N 15059751 N19520Ag Avventures LLC · Hartford, WIS/N 15074465 N19522Cannan Aviation Inc · Georgetown, TXS/N 15074467 N19523Frana Joel A DBA · Fort Myers, FLBuilt 1973 · S/N 15074468 N19524Sutton Aircraft Salvage LLC · Palmer, AKBuilt 1973 · S/N 15074469 N19526Soebagyo Vincent · Hollywood, CABuilt 1973 · S/N 15074471 N1952MLatimore Company LLC · Snohomish, WABuilt 1975 · S/N 33701665 N19531Archer Collins Etheridge · Fairview, TXBuilt 1973 · S/N 15074476 N19534Smith Paul C Sr · Winthrop, MES/N 15074479 N1953AHarejh Ltd Holdings LLC · Seymour, TNBuilt 1953 · S/N 25582 N1953CHanafi Robert A · Wellton, AZBuilt 1953 · S/N 30502 N1953EKiley Timothy P · Loudon, NHBuilt 1953 · S/N 26003 N1953UAnstrand Charles Jason · Boise, IDBuilt 1974 · S/N U20602306 N1953ZHigginbotham Laura · Woodbine, GABuilt 1962 · S/N 15059753 N1954CBowler Robert I · Anchorage, AKBuilt 1953 · S/N 26099 N1954LSmith Cody · Fairbanks, AKBuilt 1966 · S/N U2060751 N1954MBecker Verne L · Manhattan Beach, CABuilt 1976 · S/N 18264500 N1954SBarca Sky F · Simi Valley, CABuilt 1974 · S/N 17702197

Back to AD 87-20-03 R2