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.

N2791GHoutte Edmund Michael DBA · Palmer, AKBuilt 1959 · S/N 52091N2791PMccarthy Air LLC · Palmer, AKBuilt 1955 · S/N 18-4426N2791TJoyce George E · Franklinville, NCS/N TE-384N2791WToothman John · Fairmont, WVS/N 1069N2792FRoshong Loman · Leesville, LABuilt 1966 · S/N 18256892N2792GSpeedstar Aviation LLC · Kalispell, MTBuilt 1959 · S/N 52092N2792JAndresen Leonard W · Anchorage, AKBuilt 1969 · S/N 185-1542N2792PVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1955 · S/N 18-4427N2792QPalmer Paul F · Donnelly, IDBuilt 1967 · S/N 18257992N2793GMeyer Steven D · Snohomish, WABuilt 1959 · S/N 52093N2793THaas Mark A · Ridgecrest, CABuilt 1967 · S/N D-8499N2793WSchneider Aerial Inc · Rugby, NDBuilt 1966 · S/N 3365N2793Y3y Leasing LLC · Englewood, COBuilt 1958 · S/N TD-166N2794GClark Jeremiah Jacob · Pleasant Plains, ARBuilt 1959 · S/N 52094N2794JRegistration Pending · Anchorage, AKRegistration pendingBuilt 1969 · S/N 185-1546N2794QVincer Way LLC · Centennial, COBuilt 1967 · S/N 18257994N2795FSmith Casey T · Marietta, GABuilt 1966 · S/N 18256895N2795JEndeavour Flight Training Inc · Miami, FLBuilt 1979 · S/N 17273650N2796FX-Ray Engineering Corp · Port Orange, FLS/N 18256896N2796GDouglas Cattle LLC · Douglas, AZBuilt 1959 · S/N 52096N2796TPozdolski Casey · Los Osos, CABuilt 1967 · S/N D-8491N2796WPennington Jeffrey B · Wrightwood, CABuilt 1966 · S/N 1072N2797ABlue Line Aviation LLC · Vidalia, GABuilt 1969 · S/N D-9055N2797EPalm Beach Flyers LLC · Boca Raton, FLS/N 17271324N2797FWhatley Charles J · Goliad, TXBuilt 1965 · S/N 18256897N2797JAlaska Ultimate Safaris LLC · Homer, AKBuilt 1969 · S/N 185-1555N2797TD'Angelo Brothers Development LLC · Helena, MTBuilt 1967 · S/N D-8486N2797WWebb John H Jr · Paulding, OHBuilt 1966 · S/N 1073N2798CStone Aviation LLC · Sacramento, CABuilt 1978 · S/N R18200228N2798EPumpkin Eater LLC · Tavares, FLBuilt 1978 · S/N 17271325N2798FGoodall Maurice M II · Omak, WABuilt 1966 · S/N 18256898N2798GBremerton City Flying Club · Poulsbo, WABuilt 1959 · S/N 52098N2798TPatriot Aviation Logistics LLC · Lewes, DEBuilt 1967 · S/N D-8488N2798WSb Enterprise LLC · Marshall, TXBuilt 1966 · S/N 3367N2798XElsner Kelly John · Menahga, MNBuilt 1965 · S/N 18051598N2799GMartin Aviation LLC · Scottsboro, ALS/N 52099N2799QZerden David F · Lincoln Park, NJBuilt 1972 · S/N 18261592N2799XHess James R · Heathsville, VABuilt 1965 · S/N 18051599N279AGWings Over Texas Holdings LLC · Denton, TXBuilt 2020 · S/N 4496507N279CGDelaware State University · Dover, DEBuilt 2000 · S/N 2843399N279CMMckenzie Robert A · Downers Grove, ILBuilt 1969 · S/N 18259822N279HLInternational Air Services Inc Trustee · Carson City, NVS/N 11148N279JSAnnapolis Aviation LLC · Annapolis, MDBuilt 1978 · S/N 18266499N279KMarble Rick W · Hartford, IABuilt 2014 · S/N 90859N279LAFive Star Marketing Inc · Morrisville, NCBuilt 2026 · S/N 377/USN279LGAltius Aviation LLC · Syracuse, NYBuilt 1986 · S/N 28-8611004N279MASd Aviation LLC · Danville, CABuilt 2007 · S/N 1040-2007N279MGGeorgia Aviation Authority · Eastman, GABuilt 2018 · S/N 2881020N279NDSowela Technical Community College · Lake Charles, LABuilt 2000 · S/N 2844034N279PWMauck Ryan S Trustee · Bend, ORBuilt 1985 · S/N 28-8590059
Back to AD 2007-04-19 R1