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.

N77340Slikker Enterprises Inc · Bakersfield, CABuilt 1972 · S/N 16-72 N773ACDuke Anthony Jr · Alvin, TXBuilt 1997 · S/N 1229-97 N774ACDarr Henry H · Drummond, MTBuilt 1997 · S/N 388-97 N774JBJb Air LLC · Oakwood, GABuilt 2004 · S/N 1365-2004 N7756RRegistration Pending · Roundhill, KYRegistration pendingBuilt 1946 · S/N 7AC-5568 N775ACPittman Discover Flight LLC · Oshkosh, WIBuilt 1997 · S/N 785-97 N776ACMonska Stephen M · Florence, MABuilt 1997 · S/N 1233-97 N7775SWildes Thomas · Chippewa Falls, WIBuilt 1976 · S/N 227-76 N7779JLehrkamp Mike C · Caputa, SDBuilt 1966 · S/N 536 N777DWLawless Aviation LLC · Fishers, INS/N 327-77 N777EGSherwood Thomas R · Beverly, MABuilt 1956 · S/N 7BCM-2 N777HJBallantyne Benjamin J · South China, MEBuilt 1972 · S/N 841-72 N777MRRutherford Michael A · Medina, OHBuilt 1974 · S/N 1068-75 N777UFTaylor Douglas M · Dallas, TXBuilt 1960 · S/N 166 N778ACSchaefer Timothy R · Willcox, AZBuilt 1997 · S/N 381-97 N779GS779 Aviation LLC · Dover, DEBuilt 1972 · S/N 303-72 N779RDCustom Fire Apparatus Inc · Osceola, WIBuilt 2006 · S/N 1425-2007 N77GATaliaferro John C · Abilene, TXBuilt 2003 · S/N 471-2003 N7807SSmith Travis T · Watsonville, CABuilt 1976 · S/N 584-76 N7809SJo Ann Miller Marshall · Atlanta, GABuilt 1976 · S/N 265-76 N780DMTexas Barnstormers LLC · Rogers, TXBuilt 2004 · S/N 464-2004 N7811SCrop Air LLC · Eaton, COBuilt 1976 · S/N 585-76 N7816SJ Gutwein Aviation LLC · Francesville, INS/N 286-77 N781DDJp Aero Holdings Inc · Carson City, NVS/N 7EC-553 N7825BRogers Wallace B · Salem, ORS/N 11AC-1239 N7842SDoyle Terry W · Grapevine, TXBuilt 1976 · S/N 1173-76 N7846SRegistration Pending · Conroe, TXRegistration pendingS/N 268-76 N7868SGoodwin Joseph N · Grass Valley, CABuilt 1976 · S/N 269-76 N786JPRichardson William L III · Springfield, ILBuilt 2006 · S/N 484-2006 N7877SLocker Don D · Muleshoe, TXBuilt 1976 · S/N 942-76 N787RHRushing Christian W · Savannah, GABuilt 1978 · S/N 435-78 N787STCitabria N787st LLC · Reno, NVS/N 486-2004 N787SWSpringfield Flying Service LLC · Columbia, CAS/N 204 N788ABSouthwind Ventures Inc · Madison, WIBuilt 2019 · S/N 597-2019 N788BWNelson Thomas H Jr · Chatham, MSBuilt 1997 · S/N 1230-97 N788XDonahue Patrick J · Carriere, MSBuilt 1997 · S/N 793-97 N7895SOcean Aerial Ads Inc · Berlin, MDFirst renewal noticeBuilt 1976 · S/N 586-76 N789ACNiles Air LLC · Concord, NCBuilt 2023 · S/N 629-2023 N789LED&J Training Planes LLC · Logan, UTBuilt 2023 · S/N 1211-2024 N789MAS D 789 Partners LLC · Batavia, ILBuilt 2005 · S/N 1002-2005 N789WEStoked Aero LLC · Camas, WABuilt 1992 · S/N 666-92 N78BYNorthwestern Michigan College · Traverse City, MIBuilt 2005 · S/N 974-2005 N78GCMh Aviation LLC · Foster City, CABuilt 2001 · S/N 892-2001 N78MVWhittington Rankin A Trustee · Lenoir, NCBuilt 1999 · S/N 836-99 N78PDBryant Jerry L · Punta Gorda, FLBuilt 2003 · S/N 919-2003 N78PJRothrock John W Jr · Danville, INBuilt 1978 · S/N 363-78 N78SEFlight Fundamentals Inc · Willcox, AZBuilt 2005 · S/N 1382-2005 N7902SN7902s Wings LLC · Forest City, PABuilt 1976 · S/N 332-76 N7906SNeilsen James I · Waddell, AZS/N 270-76 N790LLetourneau University · Longview, TXBuilt 2011 · S/N 1408-2011

Back to AD 2000-25-02 R1