Skip to content

Registered aircraft · 20,687

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.

N92FRGliem Robert E Jr · Eddystone, PABuilt 1979 · S/N 17273140 N92FSEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280308 N92HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 2000 · S/N 172S8642 N92LCEastern Kentucky University · Richmond, KYBuilt 1997 · S/N 17280153 N92MMAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 17266052 N9301BGimli Son LLC · Fort Lauderdale, FLBuilt 1980 · S/N 172RG0786 N9301ERyan Aircraft Holding LLC · Orlando, FLBuilt 1979 · S/N 17272216 N9303NWings Over Texas Holdings LLC · Denton, TXBuilt 2011 · S/N 172S11118 N9304HWischmeyer Matthew R · Hopewell Junction, NYBuilt 1975 · S/N 17266078 N9305NRancho Av Leasing LLC · Temecula, CABuilt 2011 · S/N 172S11132 N9306HAnycomm Corp · Gold River, CABuilt 1975 · S/N 17266079 N9307DAviatzone LLC · Fort Lauderdale, FLBuilt 1982 · S/N 172RG1114 N9310DRegistered aircraftBuilt 1982 · S/N 172RG1116 N9310HLilienthal Donald W · Cyrus, MNBuilt 1975 · S/N 17266080 N9313BAirplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1980 · S/N 172RG0788 N9313DSteneker Siardus L · Vashon, WABuilt 1983 · S/N 172RG1117 N9313HFlying Ten Flying Club · Phoenix, AZBuilt 1975 · S/N 17266081 N9314EHall Kenneth B · Merritt Island, FLBuilt 1979 · S/N 17272220 N9315DZoviv Michael · Hollywood, FLBuilt 1982 · S/N 172RG1118 N9315ESmith Mark S · Cornville, AZS/N 17272221 N9318BAnderson Daniel R · Venus, TXS/N 172RG0790 N9319HHoffman Stanley L Jr · Bethel, AKBuilt 1975 · S/N 17266084 N931MSColeman Aviation LLC · Livingston, TNBuilt 1968 · S/N 17257349 N9320DDodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N 172RG1119 N9320HPlane Tail LLC · Bethany, CTBuilt 1975 · S/N 17266085 N9321EMertinez Matos Daniel Enrique · Fajardo, PRS/N 17272225 N9322CWaters David J · Phelps, NYBuilt 1959 · S/N 46402 N9323ESchock Richard F II · Peoria, ILBuilt 1979 · S/N 17272226 N9326DAll Seasons Aviation LLC · Laredo, TXBuilt 1982 · S/N 172RG1122 N9326EWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 17272228 N932AZN932az LLC · Miami, FLBuilt 1986 · S/N 17276586 N932FGTextron Aviation Inc · Wichita, KSS/N 172S13645 N932RKRegistration Pending · Palmer, AKRegistration pendingBuilt 1957 · S/N 36298 N9334HFree State Flying Club · College Park, MDBuilt 1975 · S/N 17266092 N9337EMarianas Air Transfer Inc · Saipan, MPBuilt 1979 · S/N 17272230 N9337HLorraine'S Blue Sky Aviation LLC · Norman, OKBuilt 1975 · S/N 17266095 N9338BTopp Jason · Grace City, NDBuilt 1981 · S/N 172RG0799 N9338HSchab Davis Maragaret A · Spangle, WABuilt 1975 · S/N 17266096 N933LAMindy Limited LLC · Muscatine, IABuilt 1998 · S/N 17280640 N933PAerowood Aviation LLC · Monroe, NCBuilt 1964 · S/N 17252361 N9341HAndreas Neil A · Yakima, WABuilt 1975 · S/N 17266099 N9342HGutierrez Ricardo · Downey, CABuilt 1975 · S/N 17266100 N9342TChristiansen Aviation LLC · Wilmington, DEBuilt 2011 · S/N 172S11153 N9343DAva Aviation LLC · Tappan, NYBuilt 1982 · S/N 172RG1128 N9344FAtp Aircraft 2 LLC · Wilmington, DEBuilt 1997 · S/N 17280166 N9344HBarnstormers Flying Club Inc · Pulaski, TNBuilt 1975 · S/N 17266102 N9344LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276543 N9345LHaynie Aviation LLC · Alexander City, ALBuilt 1986 · S/N 17276544 N9346DHolloway James H · Merritt Island, FLBuilt 1982 · S/N 172RG1129 N9347HWings Like Eagles LLC · Wilmington, DEBuilt 1975 · S/N 17266105

Back to AD 90-06-03 R1