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.

N2891ZSale Reported · Lantana, TXSale reportedBuilt 1978 · S/N 375-78 N2892EJaars Inc · Waxhaw, NCBuilt 1978 · S/N 17271363 N2893EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271364 N2893XOlson Philip D · Garden Plain, KSBuilt 1967 · S/N 17700293 N2894QFerkin Mark A · Caldwell, IDBuilt 1971 · S/N 17259894 N2895GWilkins Ranch Inc · Marsland, NEBuilt 1967 · S/N 175 N2895QAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259895 N2895XBoydn2895x LLC · Santa Cruz, CABuilt 1967 · S/N 17700295 N2895ZRao Enterprises LLC · Brighton, MIS/N 1242-78 N2896EFlight Club 502 Inc · Louisville, KYBuilt 1978 · S/N 17271365 N2896QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17259896 N2896ZPotts Blaize D · Port Angeles, WABuilt 1978 · S/N 376-78 N2898XOzment Dennis W · Palmyra, MOS/N 17700298 N2899GYoungpeter David L · Spencerville, OHBuilt 1968 · S/N 177 N289DMTros Corp · Wilmington, DEBuilt 1998 · S/N 401-98 N289JKFlightpath Aviation Services Inc · Brooksville, FLBuilt 1976 · S/N 17267701 N289MEWaseca Wings Inc · Owatonna, MNBuilt 1990 · S/N 243197 N289PSWillkris Aviation Services LLC · Smithfield, VABuilt 1972 · S/N 370-72 N289SAReed Gary · Bethel, OHBuilt 2005 · S/N 993-2005 N289SRFedora Lisa L · Southampton, MABuilt 1973 · S/N 435-73 N28CEKohles Aviation LLC · Norfolk, NEBuilt 1978 · S/N 24-0554 N28CMFiorita Vincent L · Wooster, OHBuilt 2004 · S/N 485-2004 N28FACivil Air Patrol · Maxwell Afb, ALBuilt 1980 · S/N 17274208 N28FYValiair Limited Co Trustee · Casper, WYBuilt 1981 · S/N 24-1219 N28GMooneyham Mark · Auburn, CABuilt 1974 · S/N 434-74 N28GKMay Aviation LLC · San Diego, CABuilt 2003 · S/N 918-2003 N28HAHonaker Group LLC · Sellersburg, INBuilt 1978 · S/N 17271942 N28JMWestern Aviation Services LLC · Cheyenne, WYBuilt 1979 · S/N P21000431 N28JWMower Michael · Kalispell, MTBuilt 1979 · S/N R18200929 N28RJMisch Keith · Bayonne, NJS/N 172RG0869 N28SESr Holdings LLC · Palmer, AKBuilt 2005 · S/N 1389-2005 N28SMMississippi Forestry Commission · Pearl, MSBuilt 1981 · S/N 17274744 N28WJAerinova Inc · Mattoon, ILBuilt 1978 · S/N 17270054 N28XArdis Mitchell Farm LLC · Winnsboro, TXBuilt 1964 · S/N 347 N29001Geske Sales & Service · Enderlin, NDBuilt 1974 · S/N 17264092 N29006Fancy Inc · Iowa City, IABuilt 1974 · S/N 17264093 N2900ECentaurus LLC · Ontario, CABuilt 1978 · S/N 17271368 N2900XHenslee Eric J · Grosse Ile, MIBuilt 1967 · S/N 17700300 N2901XErwin Brandon · Jacksboro, TXBuilt 1967 · S/N 17700301 N29028Service Oriented Aviation Readiness (Soar) · Bolivar, MOBuilt 1974 · S/N 17264095 N2902LIvey Steven L · Graniteville, SCBuilt 1967 · S/N 670065 N2903LSchillinger Bradley Charles · Honeoye Falls, NYBuilt 1967 · S/N 670066 N2903XBrowning Mcpherson Aviation LLC · Auburn, KYBuilt 1967 · S/N 17700303 N29047State College Pilots Club · Philipsburg, PABuilt 1974 · S/N 17264096 N29056Land Of Lakes Aviation LLC · Eagle River, WIBuilt 1974 · S/N 17264097 N2905ECappadona Roy · Iliamna, AKBuilt 1978 · S/N 17271369 N2905LSteel Alan P · Odessa, TXBuilt 1967 · S/N 670299 N2905XRudy Schmitt · Brookshire, TXBuilt 1967 · S/N 17700305 N2905ZWmh Aviation LLC · Buckley, WABuilt 1978 · S/N 358-78 N2906LHogue Aviation LLC · Dover, PABuilt 1967 · S/N 670300

Back to AD 80-25-07 R1