Skip to content

Registered aircraft · 25,367

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N131MTWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17262525 N131PMDodge Sean · Littleton, NHS/N 462-2004 N131RAFlorida Institute Of Technology · Melbourne, FLBuilt 2003 · S/N 1389-2003 N131RCNordman Clay DBA · Catheys Valley, CAFirst renewal noticeBuilt 1996 · S/N 376-96 N131SEHouseman Steven · Chillicothe, OHBuilt 2006 · S/N 490-2006 N131SGPrewitt Thomas R · Hope Mills, NCBuilt 2002 · S/N 1324-2002 N131VUMalisa Michael D · Goodyear, AZBuilt 1985 · S/N 172RG1191 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 N1320WBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 208 N13211Robinson Rick J · Rocky Mount, MOBuilt 1973 · S/N 17262577 N13219Reboot Charity Inc · West Palm Beach, FLBuilt 1973 · S/N 17262584 N13221Cm3 LLC · North Las Vegas, NVBuilt 1973 · S/N 17262586 N13226Koons Harry D · Salem, OHBuilt 1973 · S/N 17262589 N13228Leader Aviation LLC · Glasgow, MTBuilt 1973 · S/N 17262591 N1322EStrohman William Edward · Algona, IABuilt 1978 · S/N 17270954 N1322XGrecor LLC · Ashville, ALBuilt 2015 · S/N 1163-2015 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 N1324ESorbi Aviation Inc · El Cajon, CABuilt 1978 · S/N 17270956 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 N1325FA&F Aviation Services LLC · Collierville, TNBuilt 1979 · S/N 17272995 N13261Tyler Parker H · Skowhegan, MEBuilt 1973 · S/N 17262620 N13262Cloud Dance Aviation Inc · Deland, FLBuilt 1973 · S/N 17262621 N13263Fraini Frederick D Jr Trustee · Auburn, MABuilt 1973 · S/N 17262622 N13266Korb Charles · Edmond, OKBuilt 1973 · S/N 17262624 N13268Empire Aviators LLC · Long Island City, NYS/N 17262626 N13269Hansen Scott K · Bowman, NDS/N 17262627 N13275Echo 7 Tango Aviation LLC · Gunter, TXBuilt 1973 · S/N 17262631 N13276N13276 LLC · Myrtle Beach, SCBuilt 1973 · S/N 17262632 N13277Ultimate Aviation LLC · Lowell, ARBuilt 1973 · S/N 17262633 N13278Kinney Loren Dakotah · Orla, TXBuilt 1973 · S/N 17262634 N1327WHexom Nathan R · Bozeman, MTBuilt 1963 · S/N 215 N13282Cook Thomas H · Harbor Springs, MIBuilt 1976 · S/N 17702406 N13283N13283 LLC · Greenville, SCBuilt 1973 · S/N 17262638 N13285Royalty Flight Solutions LLC · West Babylon, NYBuilt 1976 · S/N 17702407

Back to AD 80-25-07 R1