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.

N3371RRs Helicopters Inc · Winter Haven, FLS/N 3371N3371TSale Reported · Sanderson, TXSale reported, pending cancellationBuilt 1967 · S/N 17700671N3371YChavers Finley L · Newnan, GABuilt 1962 · S/N 18254371N33727Cohran Chuck Earl · Bowdon, GABuilt 1975 · S/N 28-7515358N33728Howard Andrew · Chillicothe, OHBuilt 1975 · S/N 28-7505173N3372DWings Like Eagles Aviation LLC · Newnan, GABuilt 1955 · S/N 32170N3372FSwanner Robert Craig II · Water Valley, MSBuilt 1966 · S/N 18257372N3372MFarah Michael J · Mclean, VABuilt 1980 · S/N 28-8011059N3372SBmf Services USA LLC · Satellite Beach, FLBuilt 1969 · S/N 21059172N3372ULeading Edge Operations LLC · Knoxville, TNBuilt 1963 · S/N 18254772N3372XLeahy David J · Delaware, OHBuilt 1966 · S/N 670028N3372ZPhilbrick Stephen C · Oquossoc, MEFirst renewal noticeBuilt 1960 · S/N 18-7245N33733Swink Cory A · Gold Hill, NCBuilt 1975 · S/N 28R-7535184N33735Mcenaney John E · Orlando, FLBuilt 1975 · S/N 28-7510058N3373DCarpenter Marshall Owen · Isanti, MNBuilt 1956 · S/N 32171N3373LHowell Nicholas A · Englewood, COBuilt 1967 · S/N 185-1325N3373RSkylane N3373r LLC · Rancho Cucamonga, CABuilt 1967 · S/N 18258673N3373SWestern Metal Products LLC · Ellensburg, WABuilt 1964 · S/N 18255390N3373URms Industrial Sales LLC · Neenah, WIBuilt 1963 · S/N 18254773N33745Hunt Joel P · Berlin, WIBuilt 1975 · S/N 28-7515359N33746Lynch Ryan · Gilroy, CABuilt 1975 · S/N 28-7505175N3374DScootair LLC · Alburgh, VTBuilt 1955 · S/N 32172N3374LLewallen William J · Eloy, AZBuilt 1967 · S/N 185-1326N3374M74 Mike LLC · Ft Mitchell, KYBuilt 1977 · S/N 28-7890297N3374SCcf Ventures Inc · Bangor, MEBuilt 1969 · S/N 21059174N3374TLazy Eight LLC · Kalispell, MTS/N 17700674N3374UMurphy & Son Construction Inc · Brownsville, VTBuilt 1963 · S/N 18254774N3374WMcfadyen Joseph P · Florence, SCS/N 32-220N3374XLee Rollin Kim · Panaca, NVS/N 1091N3374YRegistered aircraftBuilt 1962 · S/N 18254374N3374ZKing Paul E · Albany, ORBuilt 1959 · S/N 18-7249N33750Geek Air LLC · Wilmington, NCBuilt 1975 · S/N 28R-7535187N33754Pietsch Aircraft Restoration And Repair Inc · Minot, NDBuilt 1975 · S/N 28-7515360N33755Stearns Patricia M · Pooler, GABuilt 1975 · S/N 28-7505176N33759Flight Time Club LLC · Searcy, ARFirst renewal noticeBuilt 1975 · S/N 28R-7535188N3375DQualls Randy J · Claremore, OKBuilt 1955 · S/N 32173N3375FKintner William R · Port Angeles, WABuilt 1966 · S/N 18257375N3375LRowan William · New Fairfield, CTBuilt 1967 · S/N 185-1327N3375RRoyellair LLC · Stone Mountain, GABuilt 1967 · S/N 18258675N33762Wits-Sims LLC · Canal Winchester, OHS/N 28-7525235N33763Elon Aviation LLC · Burlington, NCBuilt 1975 · S/N 28-7515361N33764Ps Aviation Inc · Granada, MNBuilt 1975 · S/N 28-7505178N3376DHammond James F · Yellow Springs, OHBuilt 1955 · S/N 32174N3376GLindsay Aviation Inc · West Seneca, NYBuilt 1976 · S/N 310R0818N3376RStumm Robert W · Cadott, WIBuilt 1967 · S/N 18258676N3376XVanmeter Investments LLC · Tecumseh, OKBuilt 1966 · S/N 3380N3376YFly Greater Breezewood LLC · Clearville, PABuilt 1962 · S/N 18254376N33770Bassett Christopher D · Robbinsville, NCS/N 28R-7535191N33772Land Of Lincoln Flying Club Inc · Mattoon, ILBuilt 1975 · S/N 28-7505180N3377PFlying High LLC · Gore, VABuilt 1958 · S/N 23-1337
Back to AD 2007-04-19 R1