Registered aircraft · 896

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:99-15-04-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:99-15-04-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:99-15-04-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:99-15-04-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:99-15-04-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:99-15-04-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.

N747THPhilburto Consulting Ltd · Telluride, COBuilt 2006 · S/N 4636392 N74EEFarr Aviation LLC · Tullahoma, TNBuilt 1999 · S/N 4636215 N74LM74lm Travel LLC · Austin, TXBuilt 2011 · S/N 4636516 N751CCMenlo Aviation LLC · Camden, DEBuilt 2023 · S/N 4636831 N754MAFimo Air Ltd · Wilmington, DEBuilt 1986 · S/N 46-8608057 N754WAGreenview Renewables LLC · Folsom, CABuilt 2019 · S/N 4636754 N755FGBarker Consulting Group LLC · Hickory, NCBuilt 2019 · S/N 4636755 N757TTDuellman Todd J · Wisconsin Rapids, WIBuilt 2019 · S/N 4636757 N75KDJp1 LLC · San Angelo, TXBuilt 1998 · S/N 4636178 N762VARomeo Holdings LLC · Castle Pines, COBuilt 2021 · S/N 4636785 N764WAAlcyone Trust Corp Trustee · Wichita, KSBuilt 2020 · S/N 4636764 N7688Jte Properties LLC · Azle, TXBuilt 1996 · S/N 4636055 N772DSCharleston Aviation Inc · Charleston, ILBuilt 2002 · S/N 4636338 N773JSRjb Aviation LLC · Newark, DEBuilt 1989 · S/N 4622073 N773MEConcord Flying Club LLC · Concord, NCBuilt 2015 · S/N 4636684 N773PDLria Leasing LLC · Yakima, WABuilt 2023 · S/N 4636833 N773WAEquipment Asset Management Corp · Huntington, TXBuilt 2020 · S/N 4636773 N774DMSn Holdings LLC · Des Moines, IABuilt 2020 · S/N 4636774 N775DLN775dl LLC · Orange, CABuilt 2012 · S/N 4636550 N775MKN775mk Corp Trustee · Wilmington, DEBuilt 1985 · S/N 468508068 N776AMPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4636876 N776NGMaus Air LLC · Dallas, TXBuilt 2021 · S/N 4636776 N7777FPlastech Corporation · Atlanta, GABuilt 1989 · S/N 4622016 N7777GNittany Flyin LLC · Amarillo, TXBuilt 1991 · S/N 4622118 N777ACAerozona 1 Inc · Phoenix, AZBuilt 2016 · S/N 4636687 N777JLRegistration Pending · Lighthouse Point, FLRegistration pendingBuilt 2021 · S/N 4636792 N777PGLee Christopher M · Enid, OKBuilt 2010 · S/N 4636486 N777WZM6 Aviation LLC · Acworth, GABuilt 2011 · S/N 4636491 N778MMTapley Aviation LLC · Wilmington, DEBuilt 1986 · S/N 4608012 N77DEHaag Michael E · Granite Bay, CABuilt 1987 · S/N 4608054 N77PKMagic Carpet Ride LLC · Burlington, IAS/N 4622089 N77TPSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2013 · S/N 4636575 N784CValiair Limited Company Trustee · Casper, WYBuilt 2013 · S/N 4636584 N785HCKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1999 · S/N 4636206 N786MDBas Part Sales LLC · Greeley, COBuilt 1998 · S/N 4636156 N787HPHolt Gary L · Ventura, CABuilt 1995 · S/N 4636013 N788MAir First LLC · Kalispell, MTBuilt 1986 · S/N 46-8608040 N788SM3miledawn LLC · Pensacola, FLS/N 4608116 N789JNChandelle Co · Marion, IABuilt 1989 · S/N 4622056 N78FLFlight Levels LLC · Ridgeland, MSBuilt 2005 · S/N 4636371 N792MARivas Victor · Bayport, NYBuilt 2012 · S/N 4636559 N795ABam Diversified Services LLC · Athens, TXBuilt 2014 · S/N 4636618 N795MAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1995 · S/N 4636007 N797HGBearaire LLC · Fairport, NYBuilt 1984 · S/N 46-8408064 N797MAJtcc Products LLC · Fairview Park, OHBuilt 1997 · S/N 4636108 N797MCTim 2 Fly LLC · Conroe, TXBuilt 1997 · S/N 4636117 N799JPAirship Zulu Productions LLC · Wilmington, DEBuilt 2022 · S/N 4636799 N79BLDefying Gravity Inc · Litchfield, ILBuilt 2014 · S/N 4636623 N800JSJ M S Enterprises Inc · Doylestown, PABuilt 2012 · S/N 4636534 N801DCMalibu Queen LLC · Portola Valley, CABuilt 1987 · S/N 46-08053

Back to AD 99-15-04 R1