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.

N10AAPeterson Andrew · Louisville, KYBuilt 1966 · S/N 320E0046N10ABAm Defense · St Johns, FLS/N 60-0349-126N10ADTeerlink Randall S · Hanover, VABuilt 1976 · S/N 20-1221N10AEEllison Alan T · Burien, WABuilt 2018 · S/N 3311N10AFHambelton Robert · Klamath Falls, ORBuilt 2006 · S/N 11079N10AKCygnus Holdings LLC · Ballwin, MOBuilt 1969 · S/N TE-765N10ARK Airmotive LLC · St Helens, ORBuilt 1966 · S/N U206-0738N10ASCrewson Gary · East Aurora, NYBuilt 1972 · S/N 28R-7235196N10AVMaak Holdings LLC · Missoula, MTBuilt 1999 · S/N 18280129N10BDCalkins Mark E · Longview, TXBuilt 1978 · S/N 310R1539N10BJGrifa Nathaniel A · Waterloo, NYBuilt 1980 · S/N 7-0178N10BPPeyton James L II · Granby, COBuilt 1973 · S/N D-9533N10BSB R S Leasing Inc · Wilmington, DEBuilt 1971 · S/N TE-841N10BVZondlo Todd · Phoenix, AZBuilt 1972 · S/N D-9345N10BYKing Air LLC · Navasota, TXBuilt 2005 · S/N 500-2005N10CABrunson Richard P · New Braunfels, TXBuilt 2007 · S/N E-3814N10CCSmith Kord S · Salmon, IDBuilt 1964 · S/N 206-0166N10CGWhitby Christopher W · Prescott, AZBuilt 1972 · S/N 100N10CHGulf Coast Rail Service Inc · Victoria, TXBuilt 1969 · S/N 690048N10CKKenny Edward P · Montauk, NYS/N 457MN10CRCarlile Aviation LLC · Peculiar, MOBuilt 1981 · S/N R18201808N10CXAlameda County Sheriffs Office · Livermore, CAS/N 20608082N10DBBrandon Donald A Trustee · El Monte, CABuilt 1977 · S/N 21062016N10DCHbk LLC · Lynden, WAS/N U206-05366N10DEDragoo Robert E · Raleigh, NCS/N 73-32-108N10DJNovak Todd · Lumberton, NJBuilt 1979 · S/N 17272246N10DTBernath Jacob D · Indianapolis, INBuilt 1978 · S/N TSB-1N10DUOut There Outfitters LLC · Boise, IDBuilt 1974 · S/N 18-7409071N10DWZion Gunther W · Greenfield, INBuilt 2002 · S/N 90029N10EEBucci Dennis · Pittsburgh, PABuilt 1971 · S/N D-9307N10EJPerez Julian · Sunny Isles Beach, FLS/N 61P05887963260N10ETTech Nav LLC · Columbus, INBuilt 1971 · S/N 310Q0415N10FCKnott Me LLC · Phoenix, AZBuilt 1973 · S/N 310Q0796N10FLRandall P Roumillat · Dallas, TXS/N 21062892N10FTLondonini Transport LLC · San Marcos, TXBuilt 1982 · S/N 172N10GRamsey Wayne · Abilene, TXBuilt 1979 · S/N R18201161N10GAMasiello John M · Lincolnton, NCBuilt 1998 · S/N 1047N10GCBanks Keith Allen · Salisbury, MDBuilt 1953 · S/N 30159N10GHPeters Darvin Leroy · Meservey, IAS/N 28-20482N10GLMakulu Adventures LLC · Fort Pierce, FLBuilt 1983 · S/N R18201934N10GPMaule Club Corporation · New York, NYBuilt 1999 · S/N 2016N10HFFrancis Harvey B · Fairbanks, AKS/N 22-2432N10HGGerardy Harlan D · Gruver, TXBuilt 1974 · S/N 21060169N10HLHoyt Robert H Trustee · Canby, ORBuilt 1975 · S/N 21060646N10HMAggst LLC · Shingle Springs, CABuilt 1978 · S/N 21062908N10HNMcaleer John J · Bermuda Dunes, CABuilt 1973 · S/N 409-74N10HPAviation Systems And Service LLC · Mounds, OKBuilt 2004 · S/N 18281428N10HUKentucky Taildraggers LLC · Louisville, KYBuilt 2018 · S/N 3310N10HVRegistered aircraftBuilt 1965 · S/N 715N10HYHenry Hammond Cobb Jr Foundation · Montgomery, ALBuilt 1998 · S/N 2006
Back to AD 2007-04-19 R1