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.

N5547TGoodyear Ron L · Leo, INBuilt 1964 · S/N 17251447 N55482Crook Mark E · Elberton, GABuilt 1981 · S/N 17275193 N5548RSmietanski Nathan E · Terlton, OKBuilt 1965 · S/N 17253134 N554EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12873 N554TADelta Charlie Aviation LLC · Aliso Viejo, CABuilt 2003 · S/N 172S9455 N5550JOptima Aviation LLC DBA · Lewisville, TXBuilt 1980 · S/N 17273818 N5550RMetro Technology Centers · Oklahoma City, OKBuilt 1965 · S/N 17253137 N5550TCirrus Five LLC · Merritt, NCBuilt 1964 · S/N 17251450 N55515Fly Cessna LLC · Peoria, AZBuilt 1981 · S/N 17275195 N5551TBailey Robert S · Temecula, CAS/N 17251451 N55521Carter Flygare Inc · Sacramento, CABuilt 1981 · S/N 17275196 N5552EAbove And Beyond Aviation LLC · Austin, TXS/N 17271887 N5552VJust Plane Stuff Inc · Jackson, MSBuilt 1980 · S/N 172RG0570 N5553TVan Kleek Steve D · Milford, IABuilt 1964 · S/N 17251453 N5554RRidge Rickey S · Wortham, TXBuilt 1965 · S/N 17253142 N5554TBmtc Aircraft LLC · Salem, ORS/N 17251454 N5556RWbs 1 LLC · Huron, SDBuilt 1965 · S/N 17253145 N5557TCefalu Thomas R · Louisville, MSBuilt 1964 · S/N 17251457 N5558THills Holding · Newark, DEBuilt 1964 · S/N 17251458 N5559TVance Douglas E · Cleveland, GAS/N 17251459 N555CVAviation Paradise LLC · Homestead, FLBuilt 1976 · S/N 17267112 N555FGTextron Aviation Inc · Wichita, KSS/N 172S13641 N555FNFlying Neutrons LLC · Lebanon, OHBuilt 2001 · S/N 17280999 N555GWHart Stephen M · Southampton, NJBuilt 1964 · S/N 17251353 N555LASouth Latitude Aviation Service LLC · Humble, TXBuilt 1976 · S/N 17268207 N555SLHuffman Jacob M III · Burleson, TXBuilt 1973 · S/N 17262755 N555SMWalla Walla University · College Place, WABuilt 1973 · S/N 17261805 N555WBCosta Air Service LLC · Painted Post, NYS/N 17253399 N555YSEdb Air Inc · Wilsonville, ORBuilt 2007 · S/N 172S10638 N555ZHWurth Gary P · Rochester, NYS/N 17268439 N5560TThomas Brian D · Corning, IABuilt 1964 · S/N 17251460 N5561THinson Jonathon E · Yarmouth, MEBuilt 1964 · S/N 17251461 N5562TBolles Jared R · Helena, MTS/N 17251462 N5563TPridgeon Rodger · Vero Beach, FLBuilt 1964 · S/N 17251463 N5564RLusher George W · Rigby, IDBuilt 1965 · S/N 17253156 N5564THammer Michael · Redwood Falls, MNBuilt 1964 · S/N 17251464 N5565RHaupert Steve · Hoffman Estates, ILBuilt 1965 · S/N 17253157 N5566RStoops Rickie L · Augusta, MEBuilt 1965 · S/N 17253159 N5569RAluminum Falcon LLC · Lakeland, TNBuilt 1965 · S/N 17253163 N556ERSunrise Aviation Inc · Ormond Beach, FLBuilt 2007 · S/N 172S10561 N556NDRainier Flight Service LLC · Renton, WABuilt 2009 · S/N 172S10982 N556SPTexas State Technical College · Waco, TXBuilt 1998 · S/N 172S8042 N5571RHenderson Jonathan T · Boise, IDBuilt 1965 · S/N 17253166 N5571TRegistered aircraftBuilt 1964 · S/N 17251471 N5572TAburto Lorenzo · Soldotna, AKBuilt 1964 · S/N 17251472 N5574RStrong Thomas E · Jefferson, GABuilt 1965 · S/N 17253170 N5575TRobins Tommy Jared · Bakersfield, CABuilt 1964 · S/N 17251475 N5578RSmith Robert G Jr · High Point, NCBuilt 1965 · S/N 17253176 N5579RAndress Ronald H · Bloomsburg, PABuilt 1965 · S/N 17253177 N557DJMclain Aviation LLC · Lyons, GABuilt 1973 · S/N 17262420

Back to AD 90-06-03 R1