Skip to content

Registered aircraft · 54,021

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.

N128MAFca Flight Center Inc · Fitchburg, MABuilt 1975 · S/N 17263941 N128RVande Hei Joshua G · Kaukauna, WIBuilt 1968 · S/N 17256984 N128RRRegistered aircraftS/N 15070734 N128SWRegistered aircraftBuilt 1966 · S/N 18051699 N128TTWarner Wings LLC · Yakima, WABuilt 1979 · S/N U20604991 N12901American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262356 N12902Total Flight Aircraft Leasing LLC · Apex, NCBuilt 1973 · S/N 17262357 N12908M & R Management Consulting Inc · Fort Meade, FLNon-citizen corporation, flight hours not reportedS/N 17262362 N1290KN1290k LLC · Dover, DEBuilt 1965 · S/N 18256650 N1290MGardner Michael John · Ashland, ILBuilt 1975 · S/N 18264275 N12916Jacobs Airways Inc · Wilson, WIBuilt 1973 · S/N 17262369 N12917Dewhurst Donna A · Anchorage, AKBuilt 1973 · S/N 17262370 N12918Ashland/Boyd County Regional Airport Authority · Worthington, KYBuilt 1973 · S/N 17262371 N12919Gibson Aviation Services LLC · Menomonie, WIBuilt 1973 · S/N 17262372 N1291FRegistered aircraftBuilt 1979 · S/N 17272986 N1291MCon Air Aviation LLC · Westerville, OHBuilt 1975 · S/N 18264276 N1291PPowers Elbie L · Roseboro, NCBuilt 1965 · S/N 18256573 N1291SAvidyne Corp · Melbourne, FLBuilt 1976 · S/N 18264858 N12923Roberts Cody A · Lueders, TXBuilt 1973 · S/N 17262375 N12926Norton Boe L · Carlsbad, NMBuilt 1973 · S/N 17262378 N1292CTrout Island Transit LLC · Glen Ellyn, ILBuilt 1977 · S/N 17702696 N1292DKlaerner John D · San Antonio, TXBuilt 1951 · S/N 19868 N1292FRustair Inc · Anchorage, AKBuilt 1975 · S/N 18502668 N1292MCool Change Rentals LLC · Beaufort, NCBuilt 1975 · S/N 18264277 N1292UFlynn James M · Plain City, OHBuilt 1976 · S/N 17266986 N1292YCarbiener Ross E · Kewanee, ILBuilt 1962 · S/N 15059692 N12931Walden David C · Mesa, AZBuilt 1973 · S/N 17262382 N12933Van Anda Aviation LLC · Apopka, FLBuilt 1973 · S/N 17262384 N12935Ray Aviation LLC · Burkett, TXBuilt 1973 · S/N 17262386 N12936Quinlan Patrick J · Cooper City, FLBuilt 1973 · S/N 17262387 N1293DAlder George A · Palmer, AKBuilt 1951 · S/N 19869 N1293FT-Craft Aero Club · Nampa, IDBuilt 1979 · S/N 17272987 N1293QCoxwell James L · Midlothian, TXBuilt 1971 · S/N 15072593 N1293SMeyer Raymond · Belding, MIBuilt 1976 · S/N 18264860 N12940Buffoon Flying Club · Mansfield, OHBuilt 1973 · S/N 17262388 N12943Titsworth R G · Seekonk, MABuilt 1973 · S/N 17262415 N12947Alltek Lebelle Ltd · Wilmington, DEBuilt 1973 · S/N 17262393 N1294CJel Imaging Services LLC · Rochester, NYFirst renewal noticeBuilt 1977 · S/N 17702698 N1294FClover Park Technical College · Lakewood, WABuilt 1979 · S/N 17272988 N1294QKimmons Anthony J · Bogue Chitto, MSBuilt 1971 · S/N 15072594 N1294SSheehan Dennis M · Stoughton, WIBuilt 1976 · S/N 18264861 N12951Huestis Peggy J · Havre, MTS/N 17262397 N12952Wesselhoff Rick · Sedona, AZBuilt 1973 · S/N 17262398 N12953Witmer Travis R · Odenton, MDBuilt 1973 · S/N 17262399 N12955American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262400 N1295DBlessum Jay A · Minot, NDBuilt 1950 · S/N 19871 N1295UWolff Timothy W Trustee · Monroe, WIBuilt 1976 · S/N 17266989 N12960Hennessee Timothy H · New Braunfels, TXBuilt 1973 · S/N 17262405 N12968Rtd Aviation LLC · Hillsborough, NJBuilt 1973 · S/N 17262413 N1296CLogan Tom B Trustee · Coeur D Alene, IDBuilt 1977 · S/N 17702699

Back to AD 87-20-03 R2