OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,428

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.

N1824HAthar Glenola LLC · Mars, PABuilt 1977 · S/N 28-7790346N1824JCb Flying LLC · Fulton, MOBuilt 2005 · S/N 0192N1824NMaiorana Anthony J Trustee · Clarkston, WABuilt 1981 · S/N EA-248N1824RKleissas Constantine · Wye Mills, MDBuilt 1978 · S/N R18200573N18251Rushing Daniel W III · Inlet Beach, FLS/N M-2329N18255Registration Pending · Los Olivos, CARegistration pendingS/N G-739N18256Registered aircraftBuilt 1956 · S/N 33605N1825CPellar Gregory T · Bigfork, MTBuilt 1953 · S/N 23446N1825EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12172N1825JAction Interests Inc · Southlake, TXBuilt 1976 · S/N 13015N1825LBonanza Flying Club LLC · Ogden, UTBuilt 1976 · S/N D-9877N1825QCree William H III · Long Beach, CABuilt 1977 · S/N 18503492N1825RKincaid James B · Wasilla, AKBuilt 1974 · S/N 18502540N1825SEngebretson Christopher D · Greenville, INS/N E-1898N1825ZGreentek Inc · Oroville, CABuilt 1962 · S/N 205-0025N18266Underwood Gary · Lewisville, TXBuilt 1966 · S/N 18257115N18269International Aviation Group LLC · Lake Wales, FLBuilt 1959 · S/N 23-1705N1826GSelting Mark D · Kadoka, SDBuilt 1968 · S/N 102N1826JPope County Aviation LLC · Russellville, ARBuilt 1968 · S/N 28-24257N1826LRhr Management Inc · Bancroft, WIBuilt 1976 · S/N E-845N1826TBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 28-7105105N1826VBig Blue Sky Aero LLC · Austin, TXBuilt 1997 · S/N E-3086N1826WOzark Mountain Airways LLC · Springfield, MOBuilt 1973 · S/N TC-1510N1827Hughes Michael R · Nashua, NHBuilt 1962 · S/N 2001N18271Ramsey Richard K · Houston, TXBuilt 1977 · S/N E-1068N18275Strong Tower Worship Center LLC · Delhi, LAS/N E-1071N1827AShmily Aviation LLC · Tampa, FLBuilt 2005 · S/N 18281615N1827HWard Austin · Kokomo, INBuilt 1959 · S/N 35927N1827LCone James R Jr · Lubbock, TXS/N TH-741N1827PMechel Emil C · Toledo, OHBuilt 1955 · S/N 22-2607N1827TSilverton Financial LLC · Wilmington, DES/N 28-7105106N1827XFlatland Farms LLC · Hooker, OKBuilt 1964 · S/N 18255927N1828Van Nice Alexander W · Wasilla, AKS/N 101N18280Team Holdings Inc · Sheridan, WYBuilt 1977 · S/N TJ-112N18284Condor Aviation LLC · Bethlehem, PABuilt 1977 · S/N E-1073N18287Three Wings Aviation LLC · Kalispell, MTBuilt 1977 · S/N D-10032N1828EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12173N1828FDrew Kevin · Fredonia, PABuilt 1965 · S/N 21058728N1828JLennon Arthella M · Dayton, OHS/N 28-24260N1828MCampbell Larry Lance · White Lake, MIBuilt 2000 · S/N 18280893N1828ZHorrocks Charles M · Blackfoot, IDBuilt 1962 · S/N 205-0028N18290Koelbel Scott W · Spring, TXBuilt 1977 · S/N E-1076N18291Meoli Christopher J · Rancho Mirage, CABuilt 1977 · S/N CE-724N18294Bundy Holdings LLC · Walnut Grove, MOBuilt 1977 · S/N D-10034N18296Star Flight Aviation Inc · Shreveport, LABuilt 1977 · S/N TH-844N1829AMcelligott Joseph P · Ione, ORBuilt 1952 · S/N 18-1679N1829ECorporate Airtime LLC · Clinton, MSBuilt 1981 · S/N TH-1282N1829PBoll Ryan C · Sheboygan, WIBuilt 1955 · S/N 22-2609N1829WRight Wing LLC · Newnan, GABuilt 1973 · S/N E-387N1829XWise Dennis E · Battle Ground, WAS/N 18255929
Back to AD 2007-04-19 R1