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.

N4293QKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1971 · S/N 17260193N4293YArcher N4293y LLC · Tulsa, OKBuilt 1983 · S/N 28-8390040N4293ZSuper Cub N4293z LLC · Creston, CABuilt 1967 · S/N 18-8603N42941Nistler Steve W · Helena, MTS/N 18259259N42942Mott Plane LLC · Morning Sun, IABuilt 1983 · S/N 32-8306018N42945Pollnow Dean M · West Bend, WIBuilt 1983 · S/N 32-8306020N42947N42947 LLC · Panama City, FLBuilt 1968 · S/N 18259262N42949Niemeyer Donald C DBA · Hobart, INBuilt 1968 · S/N 18259263N4294JWahner Rudolf M Jr Trustee · Aston, PAS/N 28-22663N4294NCoastal Aviation LLC · Virginia Beach, VABuilt 1983 · S/N 32R-8313011N4294QOptimized Aviation Services LLC · Huntington Station, NYS/N 17260194N4294TSopwith Camel Flying Club LLC · Salt Lake City, UTBuilt 1971 · S/N 28-7205134N42951Tiedt Randy · Parkville, MOBuilt 1968 · S/N 18259264N42955Brown Donald E Jr · Jonesboro, ARS/N 18259265N42958Havasa Enterprises LLC · Sisters, ORBuilt 1973 · S/N 18052389N4295ANy Fighter Jets · Wilmington, DES/N G-755N4295RGhost Riders Aoo LLC · Altoona, PABuilt 1983 · S/N 28-8311014N4295VMcmahon Ian R · Locust Grove, GAS/N 71732N42967Brook Daniel L · Marshall, INBuilt 1968 · S/N 18259269N42968Jelinek Spencer T · Erie, COBuilt 1973 · S/N 18052390N4296HBogart Sean A · Anchorage, AKBuilt 1948 · S/N 14-99N4296NScholz Daniel Joseph · Mantorville, MNBuilt 1983 · S/N 32-8306021N4296PInvestair LLC · Conway, ARBuilt 1959 · S/N 23-1796N4296QAirjohn LLC · Cheyenne, WYBuilt 1971 · S/N 17260196N4296SB J Air Inc · Wilmington, DEBuilt 1983 · S/N 32-8306022N4296ZSisk Michael Shaun · Steamboat Springs, COBuilt 1967 · S/N 18-8548N42972Anderson Mike D · Mc Alpin, FLBuilt 1968 · S/N 18259271N42974Tracy Lanning Construction LLC · Westminster, SCBuilt 1968 · S/N 18259272N4297547q LLC · Eau Claire, WIBuilt 1968 · S/N 18259273N4297ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1971 · S/N 39-114N4297HAirswiss Inc · Wilmington, DEBuilt 1978 · S/N 24-0699N4297MInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N 28-8316056N4297QCritchfield David P · Paradise, CAS/N 17260197N4297ZAcadiana Cub LLC · Abbeville, LAS/N 18-8549N42980Friday Dale C · Santa Cruz, CABuilt 1968 · S/N 18259274N42982Dassin Andre · Altadena, CABuilt 1983 · S/N 28-8390050N42985Hall Jason · Iron Mountain, MIBuilt 1983 · S/N 32-8306023N42987Gman Air LLC · Clayton, MOBuilt 1983 · S/N 32R-8313017N4298LToon Corey A · Carthage, TXBuilt 1983 · S/N 28-8316058N4298QDarrach Todd I · Rhome, TXS/N 17260198N4298YAir LLC · Fresno, CABuilt 2001 · S/N TH-1998N4298ZAugustine Ryan M · Talkeetna, AKBuilt 1967 · S/N 18-8555N4299HCompton James D · Griffin, GABuilt 1948 · S/N 14-103N4299PAllison Daniel H · Whittier, NCBuilt 1959 · S/N 23-1799N4299ZKauffman Loren C · Anchor Point, AKS/N 18-8558N429ACRegistration Pending · Morris, ILRegistration pendingBuilt 1999 · S/N 429-99N429AFConcho Aviation LLC · Sterling City, TXBuilt 2005 · S/N 11547N429AMAero Mark Inc · Idaho Falls, IDBuilt 2007 · S/N 2429N429BJJohnston Richard Max Trustee · Sierra Madre, CAS/N 40410N429CDQualitair LLC Trustee · MichelstadtBuilt 2004 · S/N 1064
Back to AD 2007-04-19 R1