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.

N18364Goeken Peter C · Dakota Dunes, SDBuilt 1977 · S/N TH-854N18367Benoit Farms LLC · Centralia, MOBuilt 1977 · S/N E-1103N18368Olaf LLC · Bellbrook, OHBuilt 1977 · S/N D-10049N18369Barmakian Bruce · San Bernardino, CABuilt 1977 · S/N D-10050N1836JWright James J · Edwards, MOBuilt 1968 · S/N 28-24270N1836LFlexjet LLC · Cleveland, OHBuilt 1977 · S/N E-1111N1836MCallan Donald G · Yulee, FLS/N 18264460N1836RBc Properties LLC · Anchorage, AKS/N 18502551N1836XRodney William Debaun Family Lp · Midlothian, TXBuilt 1964 · S/N 18255936N1836ZBrown Farms Inc · Central City, NEBuilt 1981 · S/N CE-970N1837Nfm Enterprises LLC · Wurtsboro, NYBuilt 1965 · S/N 2009N18378Lodi Airport Maintenance Corp · Las Vegas, NVS/N E-1106N1837HYeagley Daun III · Moraine, OHBuilt 1959 · S/N 35937N1837JTolley Derek Evan · Mckinleyville, CABuilt 1968 · S/N 28-24272N1837LHornby Mark H · New Bern, NCBuilt 1976 · S/N D-9881N1837TKettrey Keith · Waxahachie, TXBuilt 1971 · S/N 28-7105113N1837WChurchill Laurice U · Torrance, CABuilt 1981 · S/N M-2340N1837ZBert Aviation LLC · Clemmons, NCBuilt 1981 · S/N D-10317N18381Texas Aero Services 1 LLC · Frisco, TXBuilt 1977 · S/N CE-732N1838EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12174N1838GNickelson Gene A · Weskan, KSBuilt 1968 · S/N 188N1838LGordon Martin A · South Amboy, NJS/N TC-2008N1838MGenesis Aircraft Services Of Martin County LLC · Stuart, FLBuilt 1975 · S/N 18264461N1838PLarsen Steve J · Colton, ORBuilt 1955 · S/N 22-2618N1838RSix Zero Zulu LLC · Kalispell, MTBuilt 1981 · S/N E-1916N1838TN1838t LLC · Ballwin, MOBuilt 1971 · S/N 28-7105114N1838XSkinner Norman D · Osceola, IABuilt 1964 · S/N 18255938N1838ZAgee Mark L · Greenacres, WABuilt 1962 · S/N 205-0038N18390Precision Design Inc · Wilmington, DES/N 21171N18394Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N E-1121N18396Drec 0419 LLC · Carson, CAS/N TE-1109N1839EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12175N1839FHentz Randy Reuben · Tower City, PABuilt 1966 · S/N 21058739N1839RBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 18502554N1839TBluewater Airmotive Corp · Wilmington, DEBuilt 1971 · S/N 28-7125262N1839WTown & Country Auto Sales LLC · Winchester, KYBuilt 1973 · S/N TC-1514N183APennington Madison D · Oak Harbor, WABuilt 1985 · S/N SN-183N183ACSynnes Mark A · Halliday, NDS/N 728-94N183ASCorporate Helicopter Leasing · Dallas, TXBuilt 2000 · S/N 0827N183BWilliams John · Omaha, NES/N BG-414N183BBRussell Charles B DBA · Union City, TNBuilt 1978 · S/N R18200310N183CDRegistered aircraftBuilt 2004 · S/N 0921N183CFCherokee Flyers Inc · Vero Beach, FLBuilt 1999 · S/N 2843232N183CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282342N183CRBekway Builders LLC · Charleston, SCBuilt 1976 · S/N 18264029N183EHarkins Harrison J Trustee · Hayden, IDBuilt 1982 · S/N E-2034N183EXFlying W Leasing Inc · Bartlett, ILBuilt 2004 · S/N 1183N183FCarter Christopher · Houston, MSBuilt 2025 · S/N 8-4135N183FCPinnacle Medical Solutions LLC · New York, NYBuilt 2009 · S/N 90183N183JRRausch John C · Upland, CABuilt 2009 · S/N 80110
Back to AD 2007-04-19 R1