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.

N6294TGreater Flint Pilots Association · Flushing, MIBuilt 1983 · S/N R18201962 N6294ULamontagne Brian D · Wyandotte, MIBuilt 1962 · S/N 2133 N6294VColomello Charles P · Tillson, NYBuilt 1965 · S/N 661 N62953Dodge Inc · Wilmington, DEBuilt 1981 · S/N 17275367 N6295DCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 17272700 N6295URawareo LLC · Warsaw, MOS/N 2134 N6295YSkydoc LLC · Mokena, ILBuilt 1981 · S/N 21064322 N62960Fossen Kenneth J · Omaha, NEBuilt 1981 · S/N 17275368 N62968Stanley Farms · Grygla, MNBuilt 1972 · S/N 373-72 N6296FCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 17273185 N62975Quintessence World LLC · League City, TXBuilt 1972 · S/N 861-72 N62977Borgerding Richard · Piqua, OHBuilt 1972 · S/N 855-72 N62979Cummings Roy E · Fort Scott, KSBuilt 1972 · S/N 36-72 N6297YL&L Aviation LLC · Baden, PAS/N 21064323 N62982Peterson Derek R · Kenmare, NDBuilt 1972 · S/N 361-72 N62984Hopkins George · Chippewa Falls, WIBuilt 1972 · S/N 363-72 N62985Alexander Aviation LLC · Brighton, COS/N 369 N6298MLapham John R · Palm Beach Gardens, FLBuilt 1980 · S/N 15284660 N6299CCenturion Flight LLC · Auburn, WABuilt 1980 · S/N 21063858 N6299DJav Air Services LLC · Anchorage, AKBuilt 1979 · S/N 17272704 N6299NAviation Trust Co LLC · Oklahoma City, OKS/N 18267823 N6299PDanlars Aircraft Sales · Mccall, IDBuilt 1978 · S/N P21000165 N629APThomas Lucas G · Beebe, ARBuilt 1978 · S/N 266-78 N629MMMcgraw Michael T · Gainesville, GABuilt 1973 · S/N 17262164 N629PJWittmayer Mark A Trustee · Orlando, FLBuilt 2000 · S/N 443-2000 N629PKJones John Michael · Oologah, OKBuilt 2002 · S/N 1326-2002 N62CFHolochwost Anthony T · Auburn, CABuilt 1962 · S/N 2197 N62DXGlasford John T · Rapid City, SDBuilt 1962 · S/N 2187 N62FESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2013 · S/N 1124-2013 N62FTAhgl LLC · San Diego, CABuilt 1998 · S/N 808-98 N62GKAugusta Flying Club Inc · Martinez, GABuilt 1978 · S/N 17271667 N62JMVan Bergen Matthew D · Arlington Heights, ILS/N R18201834 N62PMRoberts James A · Hamburg, ARBuilt 1962 · S/N 2055 N62SK55x LLC · Kalispell, MTS/N P21000096 N62SMBell Charles S · Fort Payne, ALBuilt 1973 · S/N 17261862 N62WWPc-Ppp LLC · Jersey City, NJBuilt 2004 · S/N 940-2003 N62YRSnyder George H Trustee · Lake Worth, FLBuilt 1962 · S/N 2118 N6300NGriesman Scott W · Sandy Valley, NVBuilt 1967 · S/N 19 N6300PSchrempp Aviation LLC · Winnemucca, NVBuilt 1978 · S/N P21000166 N6300QPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1981 · S/N 15285225 N63014Taylor Daniel S · The Woodlands, TXBuilt 1981 · S/N 17275374 N63017Adams Aviation Services Inc Trustee · Wilmington, DEBuilt 1981 · S/N 17275377 N63019Althaver David B · Kearny, NJBuilt 1981 · S/N 17275379 N6301DR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17272706 N6301EJc Air Academy Inc · Stockton, CAS/N 17272004 N6301LHarding Benjamin H Jr · Yadkinville, NCBuilt 1980 · S/N 15284384 N6301QJenny Steven R · Boise, IDBuilt 1967 · S/N 670394 N6302QMerritt Chad William · Hillsborough, NCBuilt 1967 · S/N 670395 N6303NTaylor Timothy P · Watford City, NDBuilt 1967 · S/N 24 N6303QCoker Steve L Jr · Tyler, TXBuilt 1967 · S/N 670396

Back to AD 80-25-07 R1