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.

N2415PGlahn Guy R · Surprise, AZBuilt 1955 · S/N 18-4290N2415QPagel David R · Tioga, NDBuilt 1966 · S/N 18257615N2415RRegistered aircraftBuilt 1964 · S/N 18255515N2415TWeaver George T · Fairbanks, AKBuilt 1962 · S/N NAV-4-2415N24161Diamond Scenery LLC · Red Oak, TXBuilt 1978 · S/N D-10103N24165Yukon Helicopters Inc · Bethel, AKBuilt 1978 · S/N TK-78N2416CTa Ritchey LLC · Batavia, OHBuilt 1954 · S/N 30716N2416QAltitude Addiction LLC · Harker Heights, TXS/N 18257616N2416TFebruary Aviation LLC · Lake Geneva, WIBuilt 1962 · S/N NAV-4-2416N2417ASitta Donald C · Farmington, NMBuilt 1952 · S/N 22-781N2417CW & K Aviation LLC · Omro, WIS/N 30717N2417EWolthuis Ivan H · Sweet Home, ORS/N 17271274N2417KDarley Vernon O · Peachtree City, GABuilt 2024 · S/N HC 0186N2417MRens Troy D · Marshfield, WIBuilt 1977 · S/N 32R-7880064N2417PMehling Craig · Hardin, MTS/N 18-4293N2417QMcgough Julie Eileen · Red Oak, TXS/N 18257617N2417RJohary Aviation Inc · Apopka, FLS/N 18255517N2417XGerding Thomas P · Philomath, ORBuilt 1965 · S/N 18256317N24182Robert Yost Enterprises Inc DBA · Saint Francis, KSBuilt 1978 · S/N TJ-136N24183Smither Tom M · Marietta, GABuilt 1978 · S/N D-10107N24187Heil Brad C · Homer, AKBuilt 1972 · S/N 18502031N2418CBlythe Anne T · Paso Robles, CABuilt 1954 · S/N 30718N2418GSunset Cay Orc Partners LLC · Key Largo, FLS/N 51718N2418RMann Steven · High Springs, FLBuilt 1969 · S/N 28-5617N2418VHart William Kirby · Springville, CABuilt 1960 · S/N 27-81N2418XPoessel Frank George Jr · East Bernard, TXBuilt 1965 · S/N 18256318N24192Lindeman Rusty L · D Hanis, TXBuilt 1978 · S/N E-1223N24194Ge King LLC · Lewes, DEBuilt 1978 · S/N E-1222N24195Barrett Group LLC · Farwell, TXBuilt 1978 · S/N D-10110N2419FMartinez Rudy J · Wasilla, AKBuilt 1965 · S/N 18051619N2419GBig Sky Aviation LLC · Kapaau, HIBuilt 1958 · S/N 51719N2419PRegistration Pending · Lavale, MDRegistration pendingBuilt 1955 · S/N 22-3091N2419QScholl Steven G · Bluffton, SCBuilt 1966 · S/N 18257619N2419RLynch Gerald A · Santa Barbara, CABuilt 2000 · S/N 18280927N241AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281182N241AJAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1958 · S/N 35789N241AREllison Aviation LLC · Conroe, TXBuilt 1967 · S/N 320F-0012N241ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2000 · S/N 4496039N241AUCompass Aviation Inc · Shelby, NCBuilt 2008 · S/N 12592N241AWStewart Lawrence D · Council Bluffs, IABuilt 2004 · S/N 5614N241BHughes Dustin G · Texarkana, TXBuilt 2016 · S/N 571702N241BDHanus David S · Mound, MNS/N 60477N241CFPalermo Michael S · Carter Lake, IABuilt 1957 · S/N 23-1160N241CMFalgout Scott · La Place, LABuilt 2002 · S/N 0357N241DAMonard Larry R · Anadarko, OKBuilt 1960 · S/N 57563N241DKSale Reported · Wilmington, DESale reportedBuilt 2022 · S/N 367N241DWGaither William W Jr · Shallotte, NCS/N 634RGN241EPiedmont Aviation Leasing LLC · Monticello, GABuilt 1971 · S/N 17259889N241EBUsd Flyers Inc · Atlanta, GABuilt 2005 · S/N 42065N241EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2024 · S/N 172S13238
Back to AD 2007-04-19 R1