AD 2007-04-19 R1

Registered aircraft · 108,434

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.

N312BJMcneilus Grant · Dodge Center, MNBuilt 2019 · S/N CC19-0049N312BWGiacinto Lucci A Jr · Nashville, MIBuilt 1962 · S/N SP-44N312CADunn Jonathan · Murfreesboro, TNBuilt 1968 · S/N 28R-30590N312CMChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-103N312CRMjk Air LLC · Estes Park, COS/N E-23N312CSFlybuys3 LLC · Lewes, DEBuilt 1977 · S/N 310R0959N312CWLb Wings LLC · Midland, MIBuilt 1981 · S/N TH-1204N312DKline Robert H · Oley, PABuilt 2000 · S/N 29-0255N312DATspy Services Inc · Wilmington, DEBuilt 2005 · S/N 1262N312DPRotor Technologies Inc · Nashua, NHBuilt 2003 · S/N 10057N312ECAmy Johan J · Coral Springs, FLBuilt 1958 · S/N 676-27N312ESGolden Age N312es LLC · Norwalk, IABuilt 2022 · S/N 2881587N312FThree One Two Foxtrot LLC · Lexington, KYBuilt 2008 · S/N 40192N312FMBosch Jay E · Atwater, MNBuilt 2013 · S/N 82162N312JMMiller James D · Sun Prairie, WIBuilt 2004 · S/N 81175N312JTInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N 5135N312KMBaer Ryan D · Missoula, MTBuilt 1957 · S/N 32846N312LLNilsen Christopher · Livermore, CABuilt 1964 · S/N 194N312MMBadgley Robert W · Stanley, NDBuilt 1976 · S/N 25-7656085N312MXRapid Imaging Solutions LLC · American Fork, UTBuilt 1965 · S/N 310J0033N312PDValdosta Flying Service Inc · Valdosta, GABuilt 2000 · S/N 172S8408N312PSCon Air LLC · Lake Providence, LABuilt 1998 · S/N 6011N312PZMatrix Commerce Solutions LLC · Pt Pleas Bch, NJS/N 92252N312RACross Country Soaring Inc · Lonsdale, MNBuilt 1977 · S/N 12937N312RBBarcelona Russell J · Buffalo, NYBuilt 2024 · S/N MK-0077N312RHOstendorf Mark W · Santa Barbara, CABuilt 1986 · S/N 1898N312RMSunny Days Prop Jox LLC · Niceville, FLBuilt 2000 · S/N 18280872N312SCBarker Family Investments Management Co LLC · Tyler, TXBuilt 1981 · S/N 21064474N312SLKeith Shon D · Flandreau, SDBuilt 2013 · S/N 82645N312SMShelbyville Flight Academy LLC · Smyrna, TNBuilt 1977 · S/N 17270091N312TATaylor Charles E · Glen Ellyn, ILBuilt 1979 · S/N 17273565N312TDAircom Nwa LLC · Siloam Springs, ARBuilt 1976 · S/N 17266129N312TMVan Hofwegen Douglas E · Spencer, IABuilt 1973 · S/N 28-7305382N312TSWoodford John E · Madison, WIBuilt 1998 · S/N 408-98N312XYAir Surgeon I LLC · Miami, FLBuilt 2023 · S/N 18283222N312ZFink Group LLC · Philadelphia, PABuilt 1960 · S/N CD-210N31309Meadowlake Airpark LLC · Lenoir City, TNS/N TC-1524N3130CUlrich Alex E · Atlanta, ILBuilt 1954 · S/N 30929N3130FRoxy Aviation LLC · Bristol, RIBuilt 1966 · S/N 18257230N3130QDobbs Peter J · Duluth, MNBuilt 1981 · S/N 18504322N3130RN738yc LLC · Fresno, CABuilt 1969 · S/N 28R-31115N3130SN3130s Corporation · Wilmington, DEBuilt 1964 · S/N 18255630N3130UW&J Aviation And Aerial Photography LLC · Brighton, MIBuilt 1963 · S/N 18254530N3130WWarbirds East Inc · Fairhope, ALBuilt 1973 · S/N TC-1635N3130YScholz Mark W · Atchison, KSS/N 18254130N3131BShilman Nathaniel · Dickinson, NDBuilt 1973 · S/N 73-30565N3131DLeggett Brandon L · Gatesville, TXFirst renewal noticeS/N 31929N3131KAmazon Aero Corp · Wilmington, DEBuilt 1972 · S/N 402B0248N3131TSilver Express Co Db · Miami, FLBuilt 2004 · S/N 2844107N3131YPaero Contracting LLC · Middletown, OHBuilt 1962 · S/N 18254131
Back to AD 2007-04-19 R1