Skip to content

Registered aircraft · 25,370

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.

N45941G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 15282952 N45945Southwinds Export Inc · Kissimmee, FLNon-citizen corporation, flight hours not reportedS/N 15282954 N4594CSt Johns Aviation LLC · Saint Johns, MIBuilt 1979 · S/N 21063569 N4594SBlock Taylor · Sibley, IAS/N R18201351 N4596AMlfco LLC · Wilmington, DEBuilt 1978 · S/N A1520837 N4596PClements Willie E · Pembroke, GABuilt 1980 · S/N 15284776 N4598QAbanks Leasing Ltd · Wilmington, DES/N 15285040 N4599HBlake Larry Q · Suwanee, GABuilt 1979 · S/N 24-0857 N459ACFurfaro Daniel E · Saint Jacob, ILBuilt 1998 · S/N 412-98 N459RBSkydive Mississippi LLC · Jackson, MSS/N 24-1585 N45AGHogan Thomas A · Fairfield, OHS/N 17275652 N45DARegistration Pending · Fairbanks, AKRegistration pendingBuilt 1969 · S/N 17258210 N45FASilver Express Co DBA · Miami, FLBuilt 1980 · S/N 15284757 N45MAR V Aviation LLC · Thatcher, AZS/N 1074-2008 N45PPHigh Planes Air Service In · Bismarck, NDBuilt 1998 · S/N 392-98 N45RHMacfadden & Sons Inc · Sharon Springs, NYBuilt 1994 · S/N 24-3344 N45WSRandazzo Meredith · Matthews, NCBuilt 1973 · S/N 177RG0465 N45XDSubstation Air LLC · Midvale, UTBuilt 1981 · S/N 21064495 N46001Df Kitcar LLC · Red Oak, TXBuilt 1968 · S/N 17256980 N46003Carroll Michael L · Rochester, WABuilt 1968 · S/N 17256981 N4600JDavis Robert M · Dallas, NCBuilt 1979 · S/N 17273652 N4600UDlw Aviation LLC · Missoula, MTBuilt 1983 · S/N 21064789 N46011Jackson William T · Clinton, OHBuilt 1968 · S/N 17256986 N46015Leaders Flying Service LLC · Clear Lake, MNS/N 17256988 N46019La Porte Aero Club Inc · La Porte, INS/N 17256992 N4601GResicum International LLC · Gulf Shores, ALBuilt 1979 · S/N 17273270 N4601RMiddle Tennessee State University · Murfreesboro, TNS/N 172RG0003 N4601UChin-Loy Christopher Wayne Trustee · Tamarac, FLBuilt 1983 · S/N 21064790 N4601VDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1980 · S/N 172RG0336 N4601WMike Papa LLC · Newton, KSBuilt 1980 · S/N P21000622 N46020Registration Pending · Brooksville, FLRegistration pendingBuilt 1978 · S/N 15282984 N46021152 4 Fun LLC · Gilbert, SCBuilt 1978 · S/N 15282985 N46024Garfield Joshua E · Tampa, FLBuilt 1968 · S/N 17256995 N46027Cleary Thomas J · Fairport, NYBuilt 1968 · S/N 17256997 N46028First Take Aviation LLC · Van Nuys, CABuilt 1968 · S/N 17256998 N4602SKeniston Kimberly A · Tyngsboro, MABuilt 1979 · S/N R18201353 N46030Constance Air LLC · Luthersville, GABuilt 1968 · S/N 17257000 N46031Soucy Gary J · Brewer, MEBuilt 1968 · S/N 17257001 N46034Employment Services Inc · Virginia Beach, VABuilt 1978 · S/N 15282986 N46047Loudermilk John A · Nashville, TNBuilt 1968 · S/N 17257010 N4604VRogers Ann M · Traverse City, MIS/N 172RG0337 N46054Cabirdassou Meena · Arcadia, CABuilt 1968 · S/N 17257015 N46057Flight Time Builders Inc · Memphis, TNBuilt 1968 · S/N 17257018 N46060Registration Pending · Factoryville, PARegistration pendingBuilt 1968 · S/N 17257019 N46072Fly Anytime LLC · Kankakee, ILBuilt 1968 · S/N 17257025 N46075Perspective Aviation LLC · Comer, GABuilt 1978 · S/N 15282995 N46078Parrish Aviation Flight Academy LLC · Southlake, TXBuilt 1968 · S/N 17257030 N46080Sentinel Services Group LLC · Brooksville, FLBuilt 1978 · S/N 15282227 N46085Davenport Jimmy J · Hayesville, NCBuilt 1974 · S/N 17264175 N46087Range Steven V · Greenfield, ILBuilt 1968 · S/N 17257034

Back to AD 80-25-07 R1