OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,433

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
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:2007-04-19-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:2007-04-19-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.

N227YReese Michael · Phoenix, AZBuilt 2007 · S/N 20351N227YZTurtle Partners II LLC · Providence, RIBuilt 2002 · S/N 25078CN22801Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12906N22803Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12908N22806Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12911N22807Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12914N22808Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12915N22809Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12919N2280BDream Flight Aviation LLC · New Fairfield, CTBuilt 1982 · S/N TH-1344N2280RRusso John · Seaside, CAS/N T210-0430N2280TRegistered aircraftBuilt 1977 · S/N R18200016N22810Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12921N22813Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12924N22816Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12925N22818Career Pilot Training LLC · Wilmington, DEBuilt 2022 · S/N 172S12929N2281FClassic Air Aviation LLC · Mesa, AZBuilt 1967 · S/N 310L-0081N2281GBurriss James E Jr · Piedmont, SCBuilt 1958 · S/N 51581N2281QFreeman Michael J · Chillicothe, OHBuilt 1977 · S/N 28-7716096N2281SHyce Richard A · Wasilla, AKBuilt 2015 · S/N TC0604103N2281TAvpac Insurance Services Inc · Santa Ana, CABuilt 1977 · S/N R18200017N2282Inverted Taildragger LLC · Dover, DEBuilt 2018 · S/N 1904N2282FSjoblom Donald W · Maple Grove, MNBuilt 1967 · S/N 310L-0082N2283LMoser Jerald L · Tucson, AZS/N D-9948N2284CS L G Enterprises · Shelby Township, MIBuilt 1953 · S/N 30584N2284DKellner Aaron · Bloomfield, CTBuilt 1995 · S/N 1N2284LUpchurch David E · Bahama, NCBuilt 1976 · S/N E-929N2284PChickasha Wings Inc · Chickasha, OKBuilt 1957 · S/N 23-895N2284TKenley Clay · Crockett, TXBuilt 1977 · S/N R18200019N2284UAttitude Toys LLC · Wilmington, DES/N 454N2284YBorn Daniel P · Lawrence, KSBuilt 1967 · S/N 17700084N2285CIturriria John M · Kuna, IDBuilt 1953 · S/N 30585N2285GRensberger Scott C · Lake Jackson, TXBuilt 1958 · S/N 51585N2285LN2285l Aviation LLC · Robbinsville, NJBuilt 1976 · S/N E-930N2285YKrid Cardinal LLC · Centerville, INBuilt 1967 · S/N 17700085N2286LBaty John W · Ames, IABuilt 1976 · S/N CE-675N2286MRegan Herbert George · Gowen, MIBuilt 1977 · S/N 28-7816271N2287AGiacopassi Dean · Newport News, VABuilt 2002 · S/N 40.226N2287CKounovsky Jerry F · Tucson, AZBuilt 1967 · S/N 272N2287GLockwood William E · Carmel, NYS/N 51587N2287P250 Flyers LLC · Middletown, DEBuilt 1957 · S/N 23-898N2288FJ&Jn2288 LLC · Houston, TXBuilt 2018 · S/N 25428N2288GSkydive Buckeye LLC · Buckeye, AZBuilt 1958 · S/N 51588N2288PChisum Robert · Lorenzo, TXS/N 23-899N2288TRegistered aircraftBuilt 1966 · S/N 670204N2288ULay Jerry K · Minonk, ILBuilt 1966 · S/N 459N2288ZMaxwell Robert H Jr · Quincy, FLS/N 28-2196N2289ABauer Melchior E · Vallejo, CAS/N 22-677N2289BHollister Jet Center Inc · Hollister, CAS/N CE-178N2289ERegistered aircraftBuilt 1997 · S/N TH-1821N2289LOne R Aviation LLC · Newington, CTBuilt 1976 · S/N D-9949
Back to AD 2007-04-19 R1