Registered aircraft · 330

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:2003-13-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:2003-13-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:2003-13-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:2003-13-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:2003-13-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:2003-13-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.

N75105Mitchell Maverick LLC · Mitchell, SDBuilt 1994 · S/N S1677 N7511ACouch Construction Co LLC · Palestine, TXBuilt 1994 · S/N S1685 N767LHJones Aircraft Co LLC · Cross Plains, TNBuilt 2007 · S/N S1905 N776LHJones Aircraft Company LLC · Cross Plains, TNBuilt 2002 · S/N S1841 N789LHJones Aircraft Company LLC · Cross Plains, TNBuilt 2008 · S/N S1911 N801CPMoore Bradley J · Logsden, ORBuilt 1968 · S/N 980965 N801SLZadow Ryszard Jerzy · Waller, TXBuilt 1968 · S/N 880954 N8045SHenry Mark A · Dickinson, TXBuilt 1964 · S/N 85-0365 N8047LHolmes Frank L · Enterprise, ALBuilt 1967 · S/N 47-0699 N8049PFranklin Ricky L · Glade Hill, VAS/N 56-0535 N8049WTennis Gayland L · Bath, MIBuilt 1965 · S/N 75-0349 N811TTJordison Investments LLC · Auburn, WAS/N S1835 N8135LTri County Rentals And Sales Inc · Bell, FLS/N 580847 N817BWWalker Baylor L · Big Spring, TXBuilt 2001 · S/N S1813 N826JWWills John L · Jasper, ALBuilt 2001 · S/N S1826 N8363CNelson William J · Citrus Heights, CABuilt 2010 · S/N S1939 N8377FScott Shawn D · Darrington, WAS/N 480680 N839HBlair Helicopter Service Inc · Lemoore, CABuilt 1975 · S/N 1090839 N83PHValiair Limited Co Trustee · Casper, WYBuilt 2002 · S/N S1834 N8644FBemer Aviation Inc · Glastonbury, CTBuilt 1977 · S/N 770619 N8664FBarney Brooke G · Cresco, PABuilt 1977 · S/N 1170641 N8665FJack Raven · Elk Mound, WIBuilt 1977 · S/N 1070642 N868LHJones Aircraft Co LLC · Cross Plains, TNBuilt 2007 · S/N S1903 N8700FHouston Police Department · Houston, TXBuilt 2008 · S/N S1924 N8708FCruiser LLC · Munger, MIBuilt 1961 · S/N 111-0020 N8714FDown East Emergency Medicine Institute · Orono, MES/N 111-0027 N8719FKinzie Wayne · Alva, OKBuilt 1961 · S/N 121-0032 N8724FDel Rio Aviation Inc · Paso Robles, CAS/N 12-0039 N8733FLay Jerry K · Minonk, ILS/N 22-0052 N8743FPrice Keyth E · Ossian, INBuilt 1962 · S/N 42-0063 N8746FLarsen Jeffrey A · Casa Grande, AZBuilt 1962 · S/N 42-0067 N8749FTsr Sky Chicken LLC · Cleveland, TXBuilt 1952 · S/N 52-0074 N8751FLay Jerry K · Minonk, ILBuilt 1962 · S/N 52-0073 N87592Sorensen Eric N · Hilo, HIS/N 160432 N8768FReynolds Darryl G · Wills Point, TXBuilt 1962 · S/N 62-0092 N8773FSera/Southeast Regional Aviation Inc · Bowdon, GAS/N 0097 N8774FReynolds Darryl G · Wills Point, TXBuilt 1962 · S/N 0098 N8781FClements Kenneth B · Laguna Niguel, CAS/N 62-0105 N8782FDinger Kevin L · Naples, FLBuilt 1962 · S/N 0107 N8786FPrice Keyth E · Ossian, INS/N 82-0127 N87898Scott Shawn · Darrington, WAS/N 440301 N8794FMundell Terry D Trustee · Rosston, OKBuilt 1962 · S/N 103-0002 N8799FNew England Equip Corp · Auburn, MARevoked, canceledBuilt 1962 · S/N 0126 N88007Zanuzoski Alan · Hillsboro, ORS/N S1546 N8800FWaller County Aviation Museum · Waller, TXS/N 720111 N8802FMc Lane Jonathan T · Morrisville, NCRevoked, canceledBuilt 1962 · S/N 0133 N8803FAg Helicopters Inc · Ft Collins, CORegistration revokedBuilt 1962 · S/N 0134 N8821FRuhlman Dan C · Youngsville, PABuilt 1963 · S/N 0171 N8823FHudson Valley Helicopters Inc · Wilmington, DES/N 0167 N8828FJohnson Martin L · Agua Dulce, CABuilt 1963 · S/N 0173

Back to AD 2003-13-15 R1