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.

N4869JDls Aviation LLC · Gilmer, TXBuilt 1966 · S/N TE-281N4869NBlack Hawk Brothers LLC · Lakeland, FLBuilt 1979 · S/N 18267426N486ACSoaring Soul LLC · Brainerd, MNBuilt 1974 · S/N TC-1662N486AKDeckload Aviation LLC · Kodiak, AKBuilt 2020 · S/N 14408N486BLBlue Line Aviation LLC · Smithfield, NCBuilt 2024 · S/N 2881786N486CACivil Air Patrol · Maxwell Afb, ALBuilt 2025 · S/N 18283302N486CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 4496417N486CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N 18282261N486DCStephens Dana M · Coxs Creek, KYBuilt 2004 · S/N 1138N486DMMoes Sarah J · Rossford, OHS/N 32-286N486EMMason Edward R Trustee · Wilsonville, ORS/N 001N486FLBaker Donnie · Christiana, TNBuilt 1971 · S/N 28-7125295N486HPSlipstream Aviation LLC · La Crosse, WIBuilt 1989 · S/N CE-1342N486JWWade James M · Calhoun City, MSBuilt 1993 · S/N 1398N486KWilliams Lawrence J II · Tucson, AZBuilt 2005 · S/N 486N486MAOrange Wing Aviation Inc · Wilmington, DEBuilt 2006 · S/N 2843636N486MHMh Group LLC · Duncan, OKBuilt 1978 · S/N 340A0481N486MMN486mm LLC · Winter Haven, FLBuilt 2001 · S/N 136N486PRichardson Joshua R · Mobile, ALBuilt 1965 · S/N 28-21079N486PARegistered aircraftBuilt 2023 · S/N 2881621N486TCMonte D Burke · Dallas, TXBuilt 2004 · S/N 18281446N4870CHoffman Bertha M · Bethel, AKS/N 18502638N4870DSherman Hess M · Poplar Grove, ILBuilt 1979 · S/N 17272379N4870GCal Aggie Flying Farmers Inc · Davis, CABuilt 1979 · S/N 17273417N4870LWinyah Aviation LLC · Georgetown, SCBuilt 1967 · S/N 28-4225N4870TBailey Charles G · Phoenix, MDBuilt 1972 · S/N 32-7200026N4870UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842238N4871BMeise Fred Walter · Moses Lake, WAS/N 18-4967N4871CFalvey Paul J · Edgartown, MABuilt 1984 · S/N 28-8490101N4871FFry Robert S Jr · Poplar Grove, ILBuilt 1966 · S/N U206-0571N4871JGray Robert R · Granbury, TXBuilt 1966 · S/N D-8356N4871RWagner James M · Le Sueur, MNBuilt 1978 · S/N R18200615N4871SLaingkids LLC · Lewes, DES/N 32-7100017N4871VBt Aero Precission Flight Accademy LLC · Oakdale, CABuilt 1980 · S/N 172RG0406N4872AIdaho Wool Growers Assn · Boise, IDFirst renewal noticeS/N 18-4969N4872DPs N4872d LLC · Green Bay, WIBuilt 1979 · S/N 17272381N4872HPassanante John L · Newtown, PABuilt 1981 · S/N 18267849N4872JAm Aviation LLC · Edmonds, WABuilt 1966 · S/N CE-127N4872KMike Papa LLC · Newton, KSBuilt 1979 · S/N P21000351N4872LMartin Marvin J · Conrath, WIBuilt 1968 · S/N 28-4227N4872UBushwackers Leasing LLC · Calera, OKBuilt 1964 · S/N 205-0572N4873APapp Jacob R · Fort Edward, NYS/N 18-4971N4873DRagan Matthew T · Boulder City, NVBuilt 1958 · S/N 34973N4873FFirebrand Nation · Knoxville, TNS/N 28-7725034N4873G4873g Flying Club Inc · Punxsutawney, PABuilt 1979 · S/N 17273420N4873LBaker Justin · Titusville, FLBuilt 1967 · S/N 28-4229N4873RCavu Clearing LLC · Center Harbor, NHBuilt 1978 · S/N R18200616N4873SBurke Mark S · Kindred, NDBuilt 1979 · S/N R18201440N4873YCherry Hill Aviation Inc · Freetown, INBuilt 1968 · S/N 25-4675N4874Goin Jeff Trustee · Polk City, FLBuilt 1968 · S/N 025
Back to AD 2007-04-19 R1