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.

N246HNStamos Michael A · Buchanan Dam, TXBuilt 1986 · S/N 246N246JJlr Resources LLC · Naples, FLBuilt 1979 · S/N P21000355N246JBN246jb LLC · Boynton Beach, FLBuilt 1973 · S/N 28R-7435003N246JDHilliard Bruce · Grantsville, UTS/N 74-31105N246JKTobin Thomas · Sparks, NVBuilt 2000 · S/N 99197N246JMForbes Thomas L · Poland, OHBuilt 1964 · S/N 535N246JSSullivan Jason W · North Pole, AKS/N 60201N246JWPierson Janice R Trustee · Scio, ORBuilt 1981 · S/N 340A1253N246KKeeton James H · Atlanta, GABuilt 1991 · S/N 658-91N246KAStahl Richard J · Gainesville, TXBuilt 1984 · S/N 340A1817N246KWGenellie Gerald F Jr Trustee · Batavia, OHBuilt 1980 · S/N 18267659N246LSJohnson Mark · Macon, MSS/N 32185N246MEWyoming Seaplanes LLC · Alpine, WYBuilt 2000 · S/N T20608194N246MTKolquist Consulting LLC · Hermantown, MNBuilt 2003 · S/N 0760N246MWLandrum Stuart · Farmington, MOBuilt 1964 · S/N 30-678N246NSilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608246N246NDGlobal Aviation Corp · Farmingdale, NYBuilt 1999 · S/N 2842056N246PAHugie Lucas R · Logan, UTS/N 18257487N246PCLna Flyer LLC · West Palm Beach, FLBuilt 1998 · S/N 29-0173N246PKGeneva1 Aviation LLC · Mars, PABuilt 1995 · S/N 20008N246PMBesprozvanny Randy-Alexander R · San Marcos, CABuilt 1977 · S/N AA5B-0566N246RAJohnson Robert C · Dallas, TXBuilt 2005 · S/N 1398-2005N246RKFreeborn Mark Trustee · Phoenix, ORS/N 22861N246RLSwiss Eagles Inc · Las Vegas, NVBuilt 1984 · S/N L-0026N246SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13442N246SGLensis Thomas M · Wilmington, NCBuilt 2003 · S/N 473-2003N246SPWingsleasing LLC · Wichita, KSBuilt 1977 · S/N 17269023N246SRFriendship Church · Frisco, TXBuilt 2006 · S/N 042SRN246SVN246sv Corp Trustee · Wilmington, DEBuilt 2001 · S/N 25068CN246TRegistered aircraftBuilt 1981 · S/N 18268091N246TAHartman Allen L · Queen Creek, AZBuilt 1979 · S/N 80-30977N246TFMorgan Daniel D · Topeka, KSS/N R18201677N246TJLally Glen Joseph · Pleasanton, CAS/N 0382N246TMTango Mike Aviation LLC · Seneca Falls, NYS/N 3238N246TTTerry Timothy D · Gainesville, TXS/N 70518N246TWMr Dent Inc · Manheim, PAS/N 0725N246VABrascher Harry M · Spotsylvania, VABuilt 2003 · S/N 81121N246VTAkwe River Flying And Guide Service LLC · Yakutat, AKBuilt 1975 · S/N U20602822N246WBToavs Brent J · Wolf Point, MTBuilt 1969 · S/N D-8951N246WF2 4 6 Whiskey Foxtrot LLC · Knoxville, TNBuilt 1973 · S/N M-1427N247Bonewitz John A · Grapevine, TXBuilt 1999 · S/N 23846N2470BAlpha International Aircraft Inc · Lewes, DEBuilt 2005 · S/N 172S10069N2470GBaillargeon Richard W · Springville, IABuilt 1959 · S/N 51770N2470HKing Bruce J · Waldport, ORBuilt 1979 · S/N 18-7909192N2470NAlpha International Aircraft Inc · Lewes, DENon-citizen corporation, flight hours not reportedS/N 172S10187N2470QCities Aviation Services LLC · Dubberly, LABuilt 1966 · S/N 18257670N2471CCavjet LLC · Bonham, TXBuilt 1954 · S/N 30771N2471DWestern Edge Aviation LLC · Dickinson, NDBuilt 2000 · S/N 18280892N2471EWilliams Stephen H · Phoenix, AZBuilt 1982 · S/N 18268206N2471QThomas Salvatore J · Lenoir City, TNBuilt 1966 · S/N 18257671
Back to AD 2007-04-19 R1