Skip to content

Registered aircraft · 20,681

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N1328ESj28e LLC · Durango, COBuilt 1978 · S/N 17270958 N1328FSaindon Christopher M · Orlando, FLBuilt 1966 · S/N 17254823 N1328UMetildi Frederic H · Penfield, NYBuilt 1976 · S/N 17267016 N13293Atp Aircraft 2 LLC · Wilmington, DEBuilt 1973 · S/N 17262644 N13294Cmb Aviation Inc · Surf City, NCBuilt 1973 · S/N 17262645 N13295Johnson Thomas C Jr · Adrian, MIBuilt 1973 · S/N 17262646 N13296T31 Fliers LLC · Prosper, TXBuilt 1973 · S/N 17262647 N1329QGodlove Gary L · Glendale, AZBuilt 1973 · S/N 17262642 N132PFAbove And Beyond Aviation LLC · Austin, TXBuilt 1997 · S/N 17280176 N132VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281189 N13301Iowa Lakes Community College · Estherville, IAS/N 17262649 N1330NEdb Air Inc · Wilsonville, ORBuilt 2006 · S/N 172S10396 N1330YDgj Tex LLC DBA · Cleburne, TXBuilt 1961 · S/N 17249030 N1331213312 LLC · Union Gap, WABuilt 2006 · S/N 172S10401 N13319Messenger Jonathan M · Baker, MTBuilt 1973 · S/N 17262665 N1331FKing James H · Barneveld, NYBuilt 1966 · S/N 17254826 N1331YS & J 172 LLC · Florence, SCBuilt 1961 · S/N 17249031 N13320Zeytounian Nazareth · Weatherford, TXBuilt 1973 · S/N 17262666 N13323Ck Leasing Services LLC · Wilmington, DEBuilt 1973 · S/N 17262668 N13327Rodriguez Richard · Indianapolis, INBuilt 1973 · S/N 17262672 N13330Shulthise Arthur J III · Hardinsburg, KYBuilt 1973 · S/N 17262674 N13333Wooding William W · Anacortes, WAS/N 17262677 N13334Tlb Inc · Howell, NJS/N 17262678 N13337High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 17262681 N1333EEndeavour Flight Training Inc · Opa Locka, FLBuilt 2006 · S/N 172S10404 N1333MJil Aviation Inc · La Coste, TXBuilt 1972 · S/N 17260573 N1333UKellogg Larry L · Tonganoxie, KSBuilt 1976 · S/N 17267020 N13346Stafford Cessna 13346 An LLC · Lafayette, LABuilt 1973 · S/N 17262688 N1334FHamilton Alathea L · Frankfort, KYBuilt 1966 · S/N 17254829 N1334YCarranza Oscar Eusebio · San Bruno, CAS/N 17249034 N13353Irwin Kenneth F · Byron, ILBuilt 1973 · S/N 17262692 N13356Burns Jerry D · Baraboo, WIBuilt 1973 · S/N 17262694 N13358Nfh Aviation LLC · Pikeville, KYBuilt 1973 · S/N 17262696 N13364Cornerstone Aircraft Sales Inc · Wonder Lake, ILBuilt 1973 · S/N 17262702 N13365Pacific Flight Academy LLC · Honolulu, HIBuilt 1973 · S/N 17262703 N13366Tracy Shannon C · Fort Mill, SCS/N 17262704 N13367Hartline Alan G · Benton Harbor, MIBuilt 1973 · S/N 17262705 N1336FNelson David E · Windsor, VABuilt 1966 · S/N 17254831 N1336UA & F Aviation Services LLC · Collierville, TNBuilt 1976 · S/N 17267021 N13370Ratcliff Gregory W · Delaware, OHBuilt 1973 · S/N 17262707 N13373Voyagers Flying Club · Akron, OHBuilt 1973 · S/N 17262709 N13376Beahan Timothy Steven · Tampa, FLFirst renewal noticeBuilt 1973 · S/N 17262712 N13377Dean Aaron · Bella Vista, CABuilt 1973 · S/N 17262713 N13378Hare Jeffrey P · Cornelius, NCBuilt 1973 · S/N 17262714 N1337YGaipa Aircraft Inc · Saint Joseph, MIBuilt 1961 · S/N 17249037 N13383Alpha Aviation-1 LLC · Naples, FLBuilt 1973 · S/N 17262718 N13384Premier Vacations LLC · Haines City, FLBuilt 1973 · S/N 17262719 N13386Crosswind Aviation Of Oklahoma LLC · Stillwater, OKS/N 17262720 N1338FVogel Auto Repair LLC · Palmer, NEBuilt 1966 · S/N 17254833 N1338YRegistered aircraftBuilt 1961 · S/N 17249038

Back to AD 90-06-03 R1