Registered aircraft · 25,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: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.

N62093American Aircraft Sales Co · Livermore, CAS/N 17275210 N62098Delta State University · Cleveland, MSS/N 17275211 N6209C8 Waters LLC · Goodyear, AZBuilt 1979 · S/N 21063830 N6209PFly Fast Live Slow LLC · Chiefland, FLBuilt 1978 · S/N P21000151 N6209TGordon Gregory J · Bay Village, OHBuilt 1983 · S/N R18201937 N620GWBoyer Skip P · Oak Harbor, WABuilt 1972 · S/N 17260486 N62104Condor Aero Club Inc · Zelienople, PAS/N 17275213 N6210QNot For Naught LLC · Wimberley, TXBuilt 1981 · S/N 15285195 N6210TVandenakker Greg W · Whitinsville, MABuilt 1983 · S/N R18201938 N62112Southern Sky Aviation LLC · Dover, TNS/N 17275214 N6211DMcdonald Air Services LLC · Saint Johns, MIBuilt 1979 · S/N 17272638 N6212FParker Helicopter LLC · Watsonville, CABuilt 1979 · S/N 17273167 N6212GLionheart Aviation Services LLC · Fairfax, VABuilt 1979 · S/N 17273579 N6212RPliego M Guillermo M · Corpus Christi, TXS/N 172RG0117 N6212THooking Bull Investments LLC · Tallulah, LAS/N R18201939 N6212UEwart Douglas G · Kansas City, MOBuilt 1962 · S/N 2051 N6213UVan Zyll De Jong Sean M · Keenesburg, COFirst renewal noticeBuilt 1962 · S/N 2052 N62142Xin Han Aviation LLC · Atwater, CABuilt 1981 · S/N 17275218 N62144Intermill Glen M Trustee · Eagle Point, ORBuilt 1981 · S/N 17275219 N6216NHitt Kenneth A · Driftwood, TXBuilt 1980 · S/N 18267799 N6216RRegistered aircraftBuilt 1979 · S/N 172RG0119 N6218UEkstrum Eric · Mound House, NVS/N 2057 N6218YLucky Star Auto Sales Inc · Grangeville, IDBuilt 1981 · S/N 21064299 N62195Aire Services LLC · Barrigada, GUS/N 17275226 N6219AVann Dudley C · Greenville, NCBuilt 1978 · S/N 38-78A0347 N621AKelsey John · Casa Grande, AZBuilt 1980 · S/N 21064069 N621BAWilliams Travis D · Antlers, OKBuilt 1980 · S/N 15284523 N621CBAnderson Roger F · Tigard, ORBuilt 1965 · S/N 3012 N621DCResource Extension LLC · Jupiter, FLBuilt 1980 · S/N 172RG0756 N621DHPic Aviation LLC · Fort Valley, GABuilt 1978 · S/N R18200143 N621GLOverwatch Tools Inc · Chesapeake, VABuilt 2022 · S/N 1217 N621LTWood Austin F · Seattle, WABuilt 1974 · S/N 22-0064 N621PAWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15284171 N621PWSkyten Flying Club Inc · Orefield, PABuilt 1976 · S/N 17702461 N62209Christiansen Aviation LLC · Wilmington, DES/N 17275229 N6220UBarnes Dennis W · Saint Joseph, MOBuilt 1962 · S/N 2059 N62218Above The Clouds Aviation LLC · Middletown, DEBuilt 1981 · S/N 17275230 N6221BJulius Kaleb · Mesa, COBuilt 1979 · S/N 15283909 N6221UScott Terry · Panama City, FLBuilt 1962 · S/N 2060 N6223UHernandez Acosta Rodrigo Alejandro · El Paso, TXBuilt 1962 · S/N 2062 N6223VAxis Aviation LLC · Bloomingdale, GABuilt 1980 · S/N 172RG0593 N62244Christiansen Aviation LLC · Wilmington, DES/N 17275234 N6224UConti Daniel · Leonardtown, MDBuilt 1962 · S/N 2063 N6225RHartman Michael F · Montclair, CABuilt 1979 · S/N 172RG0122 N62266Skylens LLC · Hammond, LAS/N 17275239 N6227TCarpenter Cattle Co Inc · Brewster, KSBuilt 1983 · S/N R18201944 N6227UVan Tilborg Dale W · Abilene, TXBuilt 1962 · S/N 2249 N6227YWest Brook Group Inc · Pleasant Hill, IABuilt 1981 · S/N 21064301 N6227ZJet Green Aviation LLC · Terryville, CTBuilt 1990 · S/N 24-3187 N62281Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275242

Back to AD 80-25-07 R1