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.

N495CPIris Fliers Inc · Fernandina Beach, FLBuilt 1995 · S/N 29-0058N495DBWolfson Jason · Duxbury, MABuilt 1995 · S/N 372-95N495EMAround The Patch LLC · Memphis, TNBuilt 1974 · S/N 18263485N495EREmbry-Riddle Aeronautical University · Daytona Beach, FLBuilt 2019 · S/N 172S12270N495FLUrban Thomas L · Glencoe, MNBuilt 1971 · S/N 28-7125310N495GEastern Stearman Inc Trustee · Leesburg, VABuilt 2014 · S/N 1470-2014N495GCCunningham John · Naperville, ILBuilt 1981 · S/N E-1876N495HCheyney Daniel J · Nine Mile Falls, WABuilt 2007 · S/N 40252N495JCCampillo Jorge A · Miami, FLBuilt 1977 · S/N 357-77N495KKatmai Air LLC · Anchorage, AKBuilt 1974 · S/N U20602549N495KCArgenta Acquisitions LLC · Little Rock, ARBuilt 2019 · S/N 41395N495KLJones Christopher Brandt · Auburn, ALBuilt 2017 · S/N 71820N495LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2021 · S/N 28020023N495MCC182t LLC · Chattanooga, TNBuilt 2007 · S/N 18281895N495PLIntegrity Aircraft Title Holdings LLC · Portland, ORS/N 3011MN495RDCapital Holdings 226 LLC · Naples, FLBuilt 2003 · S/N 42032N495RFStewart Delbert G · Kent, OHBuilt 1973 · S/N 73-30613N495SLAlair Scott C · Pleasanton, CAS/N L2K-167N495SPFlying Start Aero Services LLC · Reno, NVBuilt 1998 · S/N 172S8036N495TCRegistered aircraftS/N 20004N495TMMacdonald Kenneth A · Willow, AKBuilt 1980 · S/N 18-8109001N495WWNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282170N4960DRasmussen Scott M · Santa Cruz, CABuilt 1958 · S/N 51060N4960JPonderosa Airtankers LLC · Safford, AZBuilt 1981 · S/N T18803791TN4960KShuck Drilling Co · Edgar, NES/N P21000383N4960LWynn Wora A · Scottsdale, AZBuilt 1967 · S/N 28-4331N4960UHopkins Breck G · North Little Rock, ARBuilt 1965 · S/N 21058660N4961AGunson Robert S · Star, IDBuilt 1956 · S/N 32358N4961ELafferty David W · Harrisburg, ORBuilt 1979 · S/N 18503922N4961GGardner Clifton T · Vernal, UTBuilt 1979 · S/N 17273508N4961JJones Charles W · La Follette, TNBuilt 1968 · S/N 28R-30710N4961KGirolami Philip · Fircrest, WABuilt 1977 · S/N 20-1232N4961LKral Aircraft LLC · Ocala, FLBuilt 1967 · S/N 28-4332N4961PSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1963 · S/N 27-562N4961THatami-Nezhad Jamshid · Encino, CABuilt 1972 · S/N 28-7225289N4961YSprenger Michael T · Hawley, MNBuilt 1973 · S/N 18-7309020N4962DMcdonald Richard Reid · Rock Island, WAS/N 51062N4962FEvans Dick G Trustee · Riverside, CABuilt 1966 · S/N U206-0662N4962GVersteeg Martin · San Antonio, TXBuilt 1979 · S/N 17273509N4962JHuffman Jacob M III · Burleson, TXBuilt 1968 · S/N 28R-30711N4962VAircraft Partner Holdings Inc Trustee · BerlinBuilt 1980 · S/N 172RG0430N4963GSunwest Aviation Inc · Santa Ynez, CABuilt 1979 · S/N 17273510N4963LBakk Dale A · Nikiski, AKBuilt 1967 · S/N 28-4334N4963NHarrison Earl S · Clarksville, TNBuilt 1979 · S/N 18267485N4963UAllen Shanda · Aynor, SCBuilt 1965 · S/N 21058663N4964AThree Sisters Capital LLC · Visalia, CABuilt 1956 · S/N 32361N4964DGrizzly Air Service Inc · Paris, TXBuilt 1958 · S/N 51064N4964FTeam Builders Inc · Carson City, NVBuilt 1966 · S/N U206-0664N4964GCrotts Aircraft Service Inc · Dodge City, KSBuilt 1979 · S/N 17273511N4964JShteyn Vladlmir · Huntingdon Valley, PABuilt 1968 · S/N 28R-30714
Back to AD 2007-04-19 R1