Skip to content

Registered aircraft · 20,683

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.

N519MPUpdike Jesse J · Kenai, AKS/N 17253042 N519NDChristiansen Aviation LLC · Wilmington, DEBuilt 2008 · S/N 172S10810 N51FACoffey Michael A · White Lake, MIBuilt 1962 · S/N 17249754 N51MSDekervor Marc Phillippe II · La Mesa, CABuilt 1970 · S/N 17259085 N51UDAlf Ix LLC · Chicago, ILBuilt 2017 · S/N 172S12088 N51WT51 Whiskey Tango LLC · Henrico, VABuilt 1969 · S/N 17258240 N5200HIowa Lakes Community College · Estherville, IABuilt 1975 · S/N 17265373 N52012Skylens LLC · Hammond, LABuilt 1980 · S/N 17274393 N52013Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 17274394 N5201EGholizadehkasgari Mary Ambanoo · Jacksonville, FLBuilt 1978 · S/N 17271767 N5201HGorge Winds Aviation Inc · Fairview, ORBuilt 1975 · S/N 17265374 N5201QAdams Clive P · Hendersonville, TNBuilt 1973 · S/N 17261770 N5201RWest Florida Flying Service LLC · Safety Harbor, FLBuilt 1974 · S/N 17263418 N5202EMcdowell William R · Corpus Christi, TXBuilt 1978 · S/N 17271768 N5202FUnited States Air Force (Owner) · Millington, TNBuilt 1965 · S/N 17253189 N5202JLizco Aviation LLC · Jackson, MOBuilt 1980 · S/N 17273729 N5202RHahn Douglas Keith · Waldport, ORBuilt 1974 · S/N 17263419 N52034Arq Aviation LLC · Wilmington, NCBuilt 2002 · S/N 172S9100 N5203DAcumen Aerotech LLC · Rogers, TXBuilt 1979 · S/N 17272446 N5203FDale County Sheriffs Office · Ozark, ALBuilt 1965 · S/N 17253192 N5203RGehman David W · Atmore, ALS/N 17263420 N52048Time Flyers LLC · East Troy, WIBuilt 1980 · S/N 17274399 N5204FUnited States Air Force · Offutt Afb, NEBuilt 1965 · S/N 17253195 N5204NN5204n LLC · Palm City, FLBuilt 2002 · S/N 172S9102 N5204VNimier Alexander M · Chatsworth, CABuilt 1980 · S/N 172RG0468 N52057Redstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 2002 · S/N 17281116 N5205DAlleghany Flying Club Inc · Hyndman, PABuilt 1979 · S/N 17272448 N5205RValley Pilots Flying Club Inc · Martinez, CABuilt 1974 · S/N 17263422 N52062Rpm Inc Flying Club · South Holland, ILBuilt 1980 · S/N 17274403 N5206RNewlon Rudolf W · Encinitas, CAFirst renewal noticeS/N 17263423 N52070Cendejas Agustin · Chino, CABuilt 2002 · S/N 172S9077 N5207FUnited States Air Force Owner · Clovis, NMBuilt 1965 · S/N 17253206 N5207QDairy Air Inc · Wyoming, PABuilt 1973 · S/N 17261771 N52082Birdsall Mark A · Berthold, NDBuilt 1980 · S/N 17274408 N5208DVarsity Flight Ops LLC · Las Vegas, NVBuilt 1979 · S/N 17272451 N5208FUnited States Air Force Owner · Beale Afb, CABuilt 1965 · S/N 17253209 N5208JFly Dreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1980 · S/N 17273732 N5208KMack Aviation Holdings LLC · Hoschton, GAS/N 17274010 N5208RL & S Flyer LLC · Old Saybrook, CTBuilt 1979 · S/N 172RG0047 N52090Bradley Flying Assoc · Peoria, ILBuilt 1980 · S/N 17274409 N5209RGuyer Kasey A · Billings, MTBuilt 1974 · S/N 17263426 N5209VHawkbill Aviation LLC · Hudson, NCBuilt 1980 · S/N 172RG0470 N520ERN520er LLC · New Orleans, LABuilt 2001 · S/N 172S8923 N520KSH2 Link Company · Lewes, DEBuilt 2004 · S/N 172S9734 N520LHH2 Link Co · Lewes, DEBuilt 2004 · S/N 172S9731 N520PLRdp Aviation LLC · Gig Harbor, WABuilt 2005 · S/N 172S9887 N520RGVaughn Freddie Allen · Yatesville, GABuilt 1963 · S/N 17250408 N52100Delta State University · Cleveland, MSBuilt 1980 · S/N 17274412 N52106Simmons Aviation Services LLC · Pawcatuck, CTBuilt 1980 · S/N 17274413 N5210AChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9118

Back to AD 90-06-03 R1