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.

N137FRMoores Aerospace Solutions LLC · Statesboro, GAS/N 17276630 N137FST Aviation Services Inc · Canovanas, PRBuilt 1975 · S/N 17266030 N137MACivil Aviation Inc · Waukesha, WIBuilt 1997 · S/N 17280146 N137MEChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 172S8420 N137RJUaa International Inc · La Verne, CABuilt 1999 · S/N 172S8296 N137VUPerformance Aircraft Sales Inc · Lincoln, NEBuilt 2003 · S/N 17281194 N13805Gateway Flight Center LLC · Port Lavaca, TXBuilt 1974 · S/N 17263009 N13806Mpr Aviation LLC · Mcpherson, KSBuilt 1974 · S/N 17263010 N13807Blues Air LLC · Shelby, MSBuilt 1974 · S/N 17263011 N1380USky Clear LLC · Chicago, ILBuilt 1976 · S/N 17267051 N13810Charlie Lima 1 LLC · Jacksonville, FLBuilt 1974 · S/N 17263012 N13821Lexington Flying Club · Lexington, KYBuilt 1974 · S/N 17263015 N1382FCloud 9 Aviation LLC · Scenery Hill, PABuilt 1966 · S/N 17254877 N13830Iowa Lakes Community College · Estherville, IABuilt 1974 · S/N 17263017 N13834Hastings Air LLC · Hastings, NEBuilt 1974 · S/N 17263018 N1383URegistered aircraftBuilt 1976 · S/N 17267054 N13849Durkee Robert J · Prineville, ORBuilt 1974 · S/N 17263021 N1385FRautio Ian · Intl Falls, MNS/N 17254880 N1385YCaracci Sam V Jr · Galesburg, ILS/N 17249085 N13874Missionair LLC · Livingston, NYBuilt 1974 · S/N 17263026 N1387FEllis Jerald K · Fort Myers, FLBuilt 1966 · S/N 17254882 N1387UCp Aircraft Leasing LLC · Danville, CABuilt 1976 · S/N 17267058 N1387YBi-County Ambulance Service Inc · Yuba City, CABuilt 1961 · S/N 17249087 N13884Triple F Aviation LLC · Scott City, KSS/N 17263028 N13887Jkg LLC · Murfreesboro, TNBuilt 1974 · S/N 17263029 N13889Carver Brian J · Rockwell City, IABuilt 1974 · S/N 17263030 N1388UBeining Grant P · Fullerton, CABuilt 1976 · S/N 17267059 N13890Registration Pending · Commerce, GARegistration pendingBuilt 1974 · S/N 17263031 N1389FBedford Aero Club Inc · Bedford, INS/N 17254884 N138FRAyotte Matthew A · South Haven, MIBuilt 1986 · S/N 17276545 N138MEA&R Aero LLC · Sacramento, CABuilt 2000 · S/N 172S8422 N138UDAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11487 N13902Campbell Travis G · Starr, SCBuilt 1974 · S/N 17263035 N13905Positive Rate LLC · Rutherford, NJBuilt 1974 · S/N 17263036 N1390YMarshall Greg J · Alexandria, VABuilt 1961 · S/N 17249090 N1391UArctic Winds Inc · King Salmon, AKS/N 17267062 N13923Timoszyk James S · Wayne, MIBuilt 1974 · S/N 17263039 N1392YDoty Douglas C · The Dalles, ORBuilt 1961 · S/N 17249092 N13938Seattle Offshore Dmi Inc · Bothell, WAS/N 17263041 N1393EMossler Jonathan E · Edgewater, FLBuilt 1978 · S/N 17270983 N1393USelim Shahir P · Hollywood, FLBuilt 1976 · S/N 17267064 N1393YHall Bret C · West Plains, MOBuilt 1962 · S/N 17249093 N13941Wings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263044 N13942Rohrer Mary · Fredericksburg, TXBuilt 1974 · S/N 17263045 N13943Tell Christopher A · Colville, WAS/N 17263046 N13944Ripp Ted · Pulaski, TNBuilt 1974 · S/N 17263047 N13946Air Capital Aviators Club · Wichita, KSBuilt 1974 · S/N 17263048 N1394FWeller Fred R · Saint Augustine, FLBuilt 1966 · S/N 17254889 N1395EHendricks Paul · Yellville, ARBuilt 1978 · S/N 17270984 N1395UBentley Robert H · Lockport, ILBuilt 1976 · S/N 17267066

Back to AD 90-06-03 R1