Registered aircraft · 826

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:90-15-15-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:90-15-15-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:90-15-15-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:90-15-15-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:90-15-15-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:90-15-15-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.

N76KFRegistration Pending · Grenada, MSRegistration pendingBuilt 1974 · S/N 153-74 N76YDBeasley Charles A · Spencer, VABuilt 1975 · S/N 199-75 N771LLBravo November LLC · Wilsonville, ORBuilt 2008 · S/N 1065-2008 N772EMelvin Daniel · Larkspur, CABuilt 2000 · S/N 849-99 N77340Slikker Enterprises Inc · Bakersfield, CABuilt 1972 · S/N 16-72 N775ACPittman Discover Flight LLC · Oshkosh, WIBuilt 1997 · S/N 785-97 N777DWLawless Aviation LLC · Fishers, INS/N 327-77 N7809SJo Ann Miller Marshall · Atlanta, GABuilt 1976 · S/N 265-76 N7816SJ Gutwein Aviation LLC · Francesville, INS/N 286-77 N7846SRegistration Pending · Conroe, TXRegistration pendingS/N 268-76 N7868SGoodwin Joseph N · Grass Valley, CABuilt 1976 · S/N 269-76 N787RHRushing Christian W · Savannah, GABuilt 1978 · S/N 435-78 N788XDonahue Patrick J · Carriere, MSBuilt 1997 · S/N 793-97 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 N7906SNeilsen James I · Waddell, AZS/N 270-76 N791KBLucky Dog Aviation LLC · Victoria, TXBuilt 2006 · S/N 1035-2007 N795ACZorba Chad · Grapevine, TXBuilt 1999 · S/N 833-99 N795JPLange Daniel C II · Oakland, CABuilt 1995 · S/N 746-95 N796TMBlack John E · Cocoa Beach, FLBuilt 1996 · S/N 779-96 N797ACWoods Gregory W · Englewood, FLFirst renewal noticeBuilt 1997 · S/N 797-97 N79ACTen G LLC · Waddell, AZS/N 708-93 N7DFSkyshoe III LLC · Beverly, MABuilt 2007 · S/N 1055-2007 N7JBB F Service Inc · Bloomington, INBuilt 1994 · S/N 727-94 N805ACSouthern Sky LLC · Henderson, NVBuilt 2005 · S/N 1001-2005 N805STDga Avition LLC · Sacramento, CABuilt 1976 · S/N 275-76 N806CInternational Divers Co Inc · Corpus Christi, TXBuilt 2010 · S/N 1100-2010 N80BDJtr Aviation LLC · Canton, TXBuilt 1980 · S/N 613-80 N80TARegistration Pending · Lancaster, CARegistration pendingS/N 632-80 N814ACAlpine Aviation Inc · Grass Valley, CABuilt 1998 · S/N 814-98 N816LLAero Equities LLC · Ventura, CABuilt 2003 · S/N 913-2003 N818WDWhiskey Bravo II LLC · Newton, KSBuilt 2000 · S/N 856-2000 N81SDBurgess Jaret F · Fort Worth, TXS/N 922-2003 N820SDBachman Ryan · Mesa, AZFirst renewal noticeBuilt 1998 · S/N 820-98 N822MWPilie Louis J · Grand Island, NYBuilt 1975 · S/N 174-75 N824SGAudenaert William N · Madison, ALBuilt 2009 · S/N 1082-2009 N829LTThompson Timothy G · Kenosha, WIBuilt 2008 · S/N 1078-2008 N82KDKizita Management LLC · Los Altos, CABuilt 2019 · S/N 1182-2019 N831AC831ac Aero LLC · Ogden Dunes, INBuilt 2000 · S/N 868-2000 N831RHHanson Paul D · Evansville, INBuilt 1997 · S/N 789-97 N838BCN838bc LLC · Naperville, ILBuilt 2025 · S/N 1223-2025 N83DHHansen Douglas M · Garden City, SDBuilt 1997 · S/N 786-96 N840WAOwatonna Warrior LLC · Owatonna, MNBuilt 2009 · S/N 1091-2009 N842ACSummit Aeronautics LLC · Dania, FLFirst renewal noticeBuilt 1999 · S/N 842-99 N842CHHall Kenneth C · Durham, NCBuilt 2007 · S/N 1043-2007

Back to AD 90-15-15 R1