Skip to content

Registered aircraft · 68,369

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-04-06-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-04-06-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-04-06-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-04-06-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-04-06-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-04-06-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.

N131RVPortman Joseph Louis III · Elmendorf, TXBuilt 2007 · S/N 70327 N131SMurphy Edward S · Zephyrhills, FLS/N 131 N131SCSum Livestock LLC · Ekalaka, MTS/N 18-7609060 N131SEHouseman Steven · Chillicothe, OHBuilt 2006 · S/N 490-2006 N131SGPrewitt Thomas R · Hope Mills, NCBuilt 2002 · S/N 1324-2002 N131UCrawford Edward J DBA · Saint Louis, MOBuilt 1993 · S/N 10163 N131VUMalisa Michael D · Goodyear, AZBuilt 1985 · S/N 172RG1191 N131WBrown Jordan Ray · Center Point, INBuilt 1946 · S/N 359 N131WBSchnell Michael L · Spearman, TXBuilt 2005 · S/N 2311 N131WTTrautmann Wolf H O · Battle Ground, WABuilt 1954 · S/N 2020/416 N13200Classic Aircraft Sales LLC · Weyers Cave, VABuilt 1973 · S/N 17262567 N13203Iowa Lakes Community College · Estherville, IABuilt 1973 · S/N 17262570 N13205Hoecher Robert T · Anchorage, AKBuilt 1973 · S/N 17262572 N13206Bishop Ronald E · Rolling Hills, CABuilt 1973 · S/N 17262573 N13208Thirty-Two Gulf Flying Club · Reston, VABuilt 1973 · S/N 17262575 N1320ATerra Firma Aviation LLC · Bowman, CABuilt 1951 · S/N 18-1126 N1320CToney Tasha Fay · Lafayette, INS/N 22-1116 N1320JHarless Steve L · Dallas, TXS/N 320 N1320WBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 208 N1321Watts John C · Matthews, NCBuilt 2019 · S/N 80231 N13219Reboot Charity Inc · West Palm Beach, FLBuilt 1973 · S/N 17262584 N1321BReck Robert Cody · Cameron, MTBuilt 1948 · S/N 5948 N1321RRamineni Raja S · Fort Mill, SCBuilt 1974 · S/N AA5-0721 N13226Koons Harry D · Salem, OHBuilt 1973 · S/N 17262589 N13228Leader Aviation LLC · Glasgow, MTBuilt 1973 · S/N 17262591 N1322AWrobel Sean M · Weatherford, TXBuilt 1951 · S/N 18-1128 N1322DGeorge Richard A · Holmen, WIS/N 1322 N1322EStrohman William Edward · Algona, IABuilt 1978 · S/N 17270954 N1322JChesley Boyd A · Cottonwood, AZS/N 513 N1322WHanley Stuart A · Hollywood, FLBuilt 1977 · S/N 035 N1323High Performance Aviation LLC · Davidson, NCBuilt 1986 · S/N 001 N13231Ace Aviation LLC · Sapulpa, OKBuilt 1973 · S/N 17262594 N13232Fly Lugu LLC · Southwick, MABuilt 1973 · S/N 17262595 N13236Eck Travis · Kingman, KSS/N 17262597 N13238Cain James W · Big Rapids, MIS/N 17262599 N13239Gusto Air LLC · Birmingham, MIBuilt 1973 · S/N 17262600 N13240Arkansas-Oklahoma Railroad Inc · Wilburton, OKBuilt 1973 · S/N 17262601 N13243Sch Aviation Inc Trustee · Sporle Kings LynnBuilt 1973 · S/N 17262604 N13249Tharp Rodney W · Thomasville, NCBuilt 1973 · S/N 17262610 N1324AJagow Charles P · Fairbanks, AKBuilt 1951 · S/N 18-1134 N1324CLawrence Mark J · Rouses Point, NYS/N 22-1131 N1324ESorbi Aviation Inc · El Cajon, CABuilt 1978 · S/N 17270956 N1324JLarson Alec M · Clermont, FLBuilt 2002 · S/N 80571 N1324UJoham James R · Kurten, TXBuilt 1976 · S/N 17267012 N1324WKcantarano LLC · Mukilteo, WABuilt 1964 · S/N 2682 N13254Richter John E · Lufkin, TXBuilt 1973 · S/N 17262614 N13255Mission Aviation Training Academy · Arlington, WABuilt 1973 · S/N 17262615 N13257Bollon Christine V · Northville, MIBuilt 1973 · S/N 17262616 N13258Smith Benjamin E · Waunakee, WIBuilt 1973 · S/N 17262617 N1325AAlaskas Cub Training Specialists LLC · Wasilla, AKBuilt 1951 · S/N 18-1139

Back to AD 90-04-06 R1