Skip to content

Registered aircraft · 54,017

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.

N4878DCache La Poudre LLC · Fairfield Bay, ARBuilt 1958 · S/N 34978 N4878FNistler Gabriel R · Helena, MTBuilt 1966 · S/N U206-0578 N4878QRichter Patrick A · Edna Bay, AKBuilt 1978 · S/N 18503570 N4878Y182b LLC · La Plata, NMBuilt 1980 · S/N 21064026 N4879DMorey Airplane Company Inc · Middleton, WIBuilt 1979 · S/N 17272384 N4879FCitizen Air LLC · Port Angeles, WABuilt 1966 · S/N U206-0579 N487MTGilmore Bobby Keith · Swifton, ARBuilt 1958 · S/N 46040 N487XACrafa Steven J · Golden, COBuilt 1973 · S/N 15075242 N4880DBernstein Timothy D · Faith, SDBuilt 1958 · S/N 34980 N4880FFkm Air Shuttle LLC · Brooklyn, NYBuilt 1979 · S/N 17273095 N4880GCifelli George J · Dothan, ALFirst renewal noticeBuilt 1979 · S/N 17273427 N4880NFront Porch Air LLC · Dalton, GABuilt 1979 · S/N 18267432 N4880UYanikoski Joseph A · Stoughton, MABuilt 1984 · S/N 21064831 N48810Training Planes LLC · Tampa, FLBuilt 1977 · S/N 15280976 N48816Feuerlein Maximilian · Tampa, FLBuilt 1977 · S/N 15280979 N4881DBurt Compton Enterprises Inc · Marfa, TXBuilt 1958 · S/N 34981 N4881EFulltron Aviation LLC · Springfield, MOBuilt 1978 · S/N 17271672 N4881QAir Dakota Flite Inc. · Hettinger, NDBuilt 1976 · S/N 18802617T N4881RSheffield Chad F · Muldrow, OKBuilt 1978 · S/N R18200619 N4881U270 W Pearl LLC · Jackson, WYS/N U20605139 N48823Silver Express Co DBA · Miami, FLS/N 15280984 N4882NCreative Strategies Inc · Proctorville, OHBuilt 1979 · S/N 18267434 N48836Messenger Air Ltd · Madrid, IABuilt 1977 · S/N 15280993 N4883DKingdom Air Corps · Sutton, AKBuilt 1958 · S/N 34983 N4883FStillinger David C · Cardiff By The Sea, CABuilt 1966 · S/N U206-0583 N4883GPlane Nuts Aviation LLC · Livingston, LABuilt 1979 · S/N 17273430 N48842Elon Aviation LLC · Burlington, NCBuilt 1977 · S/N 15280997 N48848Eaglet Flight Operations Lp · Fort Worth, TXBuilt 1978 · S/N 15281000 N4884DGarcia Robert · Arcadia, CABuilt 1958 · S/N 34984 N4884NCure Louie M · Granbury, TXBuilt 1979 · S/N 18267436 N48856Neumeister Brian K · Edwardsville, ILBuilt 1977 · S/N 15281005 N4885DSpartan National Holdings LLC · Missoula, MTBuilt 1979 · S/N 17272386 N4885GS&P Aviation LLC · Albuquerque, NMS/N 17273432 N4885XEggleston Kevin M · Moore, OKS/N 21060885 N48868Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281013 N4886DRegistered aircraftBuilt 1958 · S/N 34986 N4886GSkycrafters Inc · Johnson City, TNFirst renewal noticeBuilt 1979 · S/N 17273433 N4886NMartin Barry W Trustee · San Diego, CAS/N 18267438 N4886USkycase Leasing LLC · Wasilla, AKBuilt 1979 · S/N U20605144 N4887Carroll Daniel G · Magnolia, TXBuilt 1976 · S/N 18052720 N48878Kilo Lima Investments LLC · Huntington Beach, CABuilt 1978 · S/N 15281023 N48879Matson Dean R · Spring, TXBuilt 1977 · S/N 15281024 N4887DShank Lawrence · Pagosa Springs, COBuilt 1958 · S/N 34987 N4887GSouthern Aero LLC · Homestead, FLBuilt 1979 · S/N 17273434 N4887ZJav Air Services LLC · Anchorage, AKBuilt 1980 · S/N U20606042 N48883Fly Kful Inc · Fullerton, CABuilt 1977 · S/N 15281026 N48887Fault Line Flyers · Leander, TXBuilt 1977 · S/N 15281030 N4888CGoflight Inc · Birmingham, MIBuilt 1979 · S/N 21063656 N4888DRegistered aircraftBuilt 1958 · S/N 34988 N4888FTaktos Ltd · Corvallis, ORBuilt 1966 · S/N U206-0588

Back to AD 87-20-03 R2