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.

N303CCSpectrum Aviation Inc · Wilmington, DEBuilt 1982 · S/N T30300069N303CGSolomon Mark Trustee · Wilmington, DEBuilt 1981 · S/N T30300022N303CMAdvantage Aviation Inc · Charlotte, NCBuilt 1984 · S/N T30300296N303CTFloyd Brian · Eatonton, GABuilt 1978 · S/N 21062591N303DCatterson Paul A · Asheville, NCBuilt 2002 · S/N 5320N303DBBas Part Sales LLC · Greeley, COBuilt 1981 · S/N T30300043N303DCRegistered aircraftBuilt 1973 · S/N 402B-0303N303DKTrading Planes Inc · Wilmington, DEBuilt 1982 · S/N T303-00068N303DRShockley Lee W · Denver, COBuilt 2023 · S/N 41709N303EHNavigation Leasing LLC · Keizer, ORBuilt 2023 · S/N 172S13058N303FFInternational Air Services Inc Trustee · Carson City, NVBuilt 2025 · S/N MXS 007N303GTDelta Bravo Aviation LLC · Cleveland, MSBuilt 1980 · S/N 32R-8013094N303HLLao Che Airfreight LLC · North Weymouth, MABuilt 1982 · S/N T30300038N303HVRegistered aircraftBuilt 1994 · S/N E-2864N303JPJep Inc · Clarksville, TNBuilt 1982 · S/N T30300067N303KCCurry Kenneth R · Cookeville, TNS/N CE-1138N303KJBrother Michael Andrew · Bedford, TXBuilt 1984 · S/N T303-00301N303KSSmoky Hill Ag LLC · Healy, KSBuilt 1982 · S/N T30300223N303KTTarver Dalton K · Fallon, NVBuilt 2018 · S/N M2-938N303LKWestwind Aviation Inc · Bremerton, WABuilt 1973 · S/N 17262140N303LMRegistered aircraftBuilt 2002 · S/N 40041N303MGGeorgia Aviation Authority · Eastman, GABuilt 2026 · S/N 28010003N303MVPaden Brian · Wasilla, AKBuilt 2008 · S/N 007N303MWAccess Realty LLC · Arvada, COBuilt 2023 · S/N 92146N303NMiles James · Memphis, TNBuilt 1981 · S/N E-1880N303NADavis Clark · Shongaloo, LABuilt 2026 · S/N 1351N303PABird Acquisition LLC · Phoenix, AZBuilt 2002 · S/N 4496122N303PBPlane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N T30300290N303PPDuke Raymond E · Columbia Station, OHBuilt 1975 · S/N 28R-7535129N303RCYogini Modi · Homestead, FLBuilt 1971 · S/N 34-7250016N303RFRegion Flyers LLC · Valparaiso, INBuilt 1977 · S/N 28-7816001N303RHNavigation Leasing LLC · Kaizer, ORBuilt 2022 · S/N 172S12926N303RJTr Zato Heir Land & Cattle LLC · Spur, TXBuilt 1970 · S/N 18501728N303RMGiesbrecht Shane · Grandview, IDBuilt 1969 · S/N TC-1219N303RTTinnell Robert B · Salem, ORBuilt 2010 · S/N 22303N303SASoder Christopher R · Hewitt, TXBuilt 1971 · S/N E-303N303SBBlom Wayne E Jr · Littleton, COBuilt 2001 · S/N 887-2001N303SDHarris County Sheriff'S Office · Spring, TXBuilt 1973 · S/N 18261849N303SFSnohomish Flying Service Inc · Snohomish, WABuilt 2025 · S/N 172S13478N303SLBuffalo Aircraft Maintenance LLC · Ridgecrest, CABuilt 1994 · S/N 1201-94N303STVolar Vii LLC · Edmond, OKBuilt 2012 · S/N 172S11242N303TRegistered aircraftBuilt 1953 · S/N 18-2417N303TTCoop Aero LLC · New Albany, MSBuilt 2001 · S/N E-3377N303UTAviation Performance Solutions LLC · Mesa, AZBuilt 2001 · S/N 130N303VMiddleton Kenneth M II · Glen Allan, MSS/N 28-7690276N303WYSdl Concepts LLC · Missoula, MTBuilt 2018 · S/N 3303N303XStocki Ronald W · Centennial, COBuilt 1960 · S/N 52957N30404Cardinal Flyers LLC · Powell, OHBuilt 1969 · S/N 17701237N30407Cardinal Cronies LLC · Clarinda, IABuilt 1968 · S/N 17701238N30409Schmitt Cameron · Fort Dix, NJBuilt 1968 · S/N 17701239
Back to AD 2007-04-19 R1