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.

N2201YInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 17700001 N22034Robertson David L · Ray, MIBuilt 1974 · S/N 17264052 N2204YEagle Sky Patrol Inc · Deadwood, SDS/N 17700004 N2206YSanders Andrew · Livingston, MTBuilt 1967 · S/N 17700006 N2207ETeton Leasing LLC · Pocatello, IDBuilt 1978 · S/N 17271186 N22080Sale Reported · Las Vegas, NVSale reportedS/N 17264053 N2209EIngersoll George P · Lakewood, COBuilt 1978 · S/N 17271188 N220BDAlexander Nathan D · Melrose, IABuilt 1964 · S/N 2862 N220EPLeyva Jose Luis · New Smyrna Beach, FLBuilt 1985 · S/N 172-76484 N220FCRegistered aircraftBuilt 1993 · S/N 24-3282 N220JAHogan Field Hangars LLC · Fairfield, OHBuilt 1984 · S/N 172-76157 N220MLSaegaert Daniel G · Locust Grove, GABuilt 1968 · S/N 7ECA-651 N220NYCa Aviation 172 LLC · Santa Barbara, CABuilt 1974 · S/N 17263763 N220TSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N P21000593 N220TJJaco Oil Co · Bakersfield, CAS/N 21063139 N220TMMoore Wistar III · Savannah, GABuilt 1993 · S/N 24-3303 N220WSClark Alan R · Tucson, AZBuilt 1978 · S/N R18200260 N22101Propwash Aviation LLC · Midland, MIBuilt 1974 · S/N 17264055 N2210WGarg Ken M · Brewster, NYBuilt 1998 · S/N 24-3423 N2211WTucker Christian Taylor · Butler, MOBuilt 1964 · S/N 2875 N2211YGayle Randall K · Houston, TXBuilt 1967 · S/N 17700011 N2212WCleveland Frank W · Quinhagak, AKBuilt 1978 · S/N 17271516 N2212YSteffy Richard L · Annville, PABuilt 1967 · S/N 17700012 N2214YRegistration Pending · Tampa, FLRegistration pendingBuilt 1967 · S/N 17700014 N22177Gedney Douglas Kevin · Grand Haven, MIBuilt 1976 · S/N 177-02323 N2218YDoran Jeffrey T · Westerville, OHS/N 17700018 N2219ESorbi Aviation Inc · El Cajon, CABuilt 1978 · S/N 17271189 N221BBCendejas Agustin · Chino, CABuilt 1968 · S/N 690006 N221DMRush Aviation LLC · Melrose, NMBuilt 1971 · S/N 17260155 N221FCWest Charles E Jr · Yulee, FLBuilt 1993 · S/N 24-3289 N221HPHardie Zachary · Ypsilanti, MIBuilt 1967 · S/N 670468 N221JBMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2023 · S/N 1212-2024 N221KLMather Don · Sandusky, OHBuilt 1973 · S/N 17261348 N221MFWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267380 N221NYFarukh Shroff · Pittston, PABuilt 1981 · S/N 17274978 N221PMHester Thomas F · Boulder, UTBuilt 2004 · S/N 451-2003 N221SMMccain Stephen M · Columbia, MSBuilt 1976 · S/N 17267274 N221TJSafety In Motion Flight Center Inc · Puyallup, WABuilt 1978 · S/N 17271059 N221YDMcafee Michael D · Chandler, AZBuilt 1965 · S/N 580 N22205Venaleck Joan · Concord Township, OHBuilt 1974 · S/N 17264058 N2221YThomas Raymond N · Springfield, SDBuilt 1967 · S/N 17700021 N22230Paulsen Bryant A · Lynden, WABuilt 1974 · S/N 17264059 N2223YReynolds David Keith · Bastrop, LABuilt 1967 · S/N 17700023 N2225TBunger Richard E · Spring Branch, TXBuilt 1977 · S/N R18200001 N2226YRamjattan Enarl A · Harahan, LABuilt 1967 · S/N 17700026 N22271Ps N22271 LLC · Green Bay, WIBuilt 1974 · S/N 17264061 N2227YAdam Lewis W · Chiefland, FLBuilt 1967 · S/N 17700027 N2229ESix Pack Aviation LLC · Pocono Pines, PABuilt 1978 · S/N 17271193 N222BHLudwigson Joel R · Inver Grove, MNBuilt 1978 · S/N 24-0498 N222BKDeralex Airways LLC · Miami, FLS/N 17272887

Back to AD 80-25-07 R1