Registered aircraft · 7,563

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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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.

N8745VWhelan Thomas M · Bethlehem, CTBuilt 1975 · S/N 502-75 N8746VByron Air Service LLC · Snohomish, WAS/N 1110-75 N8747VGerald Z Morse Inc · Kalispell, MTS/N 530-75 N8748VRzadca Gene R · Wyandotte, MIBuilt 1976 · S/N 563-76 N8750Kellander Thomas · Fairmont, MNBuilt 1973 · S/N 468-73 N8750VKeller Klaus · Thetford Center, VTBuilt 1975 · S/N 1104-75 N8751Rhoads Larry E · Raymore, MOBuilt 1973 · S/N 925-73 N8751VClemens Robert Lyle · Oklahoma City, OKS/N 200-75 N8752Fender Darrell L · Colfax, WABuilt 1973 · S/N 469-73 N8752VRichard Flying Service Inc · Rayne, LABuilt 1975 · S/N 317-75 N8753Carlson Jeffrey M · La Jolla, CABuilt 1973 · S/N 361-73 N8753VScott Gorski Aviation Aerobatics · Bothell, WABuilt 1975 · S/N 201-75 N8754VLoomer Donald W · Williston, NDBuilt 1975 · S/N 855-75 N8755VBoettcher Michael W · Soldotna, AKBuilt 1975 · S/N 854-75 N8759VSmetters Jeffrey L · Crystal Lake, ILBuilt 1975 · S/N 202-75 N876SWCbc Aviation LLC · Hayden, IDBuilt 2020 · S/N 603-2020 N8779Krezel Patrick S · Wasilla, AKBuilt 1973 · S/N 926-73 N878Whalen Mark P · Millington, MDS/N 7AC-5820 N8780Gbm Aviation LLC · Los Altos, CAS/N 362-73 N8785Dahl Daniel B · Nine Mile Falls, WABuilt 1973 · S/N 363-73 N878ACDecathlon LLC · Herndon, VABuilt 2001 · S/N 878-2001 N878MAAgri Med LLC · Belgrade, MTBuilt 2006 · S/N 1415-2006 N87ECSouthwest Aircraft LLC · Las Cruces, NMBuilt 2007 · S/N 1010-2007 N87VFAgri Flite Inc · Indianola, IABuilt 2007 · S/N 1427-2007 N87VPWhite Ronald V · Overgaard, AZS/N 1422-2006 N87WAMann Ronald L · Pound Ridge, NYS/N 754-95 N87WRJohnston Donald C · Davis, CABuilt 1967 · S/N 520 N8802Osterberg Douglas · Neenah, WIBuilt 1973 · S/N 492-73 N8803Lindsay Lori K · Kenai, AKBuilt 1973 · S/N 472-73 N8804Hail Jerry D · Keatchie, LABuilt 1973 · S/N 74-73 N88047Rjr Airdrome Inc · Dover, DEBuilt 1974 · S/N 1036-74 N88055Lake Air Academy LLC · Richland, MIBuilt 1974 · S/N 715-74 N88057Registered aircraftBuilt 1974 · S/N 716-74 N88059Tidewater Soaring Society · Windsor, VAS/N 72-74 N8806Loyd Robert Oliver Parke · Wallingford, KYBuilt 1973 · S/N 364-73 N88063Evenson Gabriel J · Fargo, NDS/N 461-74 N88065Obx Airplanes LLC · Manteo, NCBuilt 1974 · S/N 460-74 N88066Nightingale Patrick R · Lakewood, CABuilt 1974 · S/N 1037-74 N8807Potter David · Huntley, ILBuilt 1973 · S/N 473-73 N88078Khm Investments Inc · Lehi, UTBuilt 1974 · S/N 464-74 N88079East Hill Flying Club Inc · Ithaca, NYBuilt 1974 · S/N 1038-74 N88081Butler Julie L · Los Osos, CABuilt 1974 · S/N 718-74 N88083N3542w Inc · Wilmington, DEBuilt 1974 · S/N 719-74 N88085Poulson Daniel J · Anchorage, AKBuilt 1974 · S/N 722-74 N88086Saliba Eric · Mineola, NYBuilt 1974 · S/N 1039-74 N8809Velociraptor Aviation LLC · Toney, ALBuilt 1973 · S/N 929-73 N88092Verhulst Charles · Reva, SDBuilt 1974 · S/N 723-74 N88098Merriwether David E · Whitesburg, GABuilt 1974 · S/N 467-74 N880MLFrusti Martin J · Goodyear, AZS/N 7AC-1882 N88110Lovas Thomas A · Anchorage, AKBuilt 1974 · S/N 725-74

Back to AD 2000-25-02 R1