OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,433

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.

N211TVSky Helicopters Inc · Garland, TXBuilt 2010 · S/N 12919N211VHull Robert Abbott · Payson, AZBuilt 1993 · S/N CE-1754N211WBBargatze Robert F · Three Forks, MTBuilt 1974 · S/N 491-75N211WFPyfl Kolby A · Maxwell, CABuilt 2015 · S/N 1075N211XSmith Amy E · Raymond, NHS/N 8N211XZDoty James A · Ocala, FLBuilt 2006 · S/N 82121N211YRegistered aircraftBuilt 1966 · S/N TE-169N211ZNAllen Michael J · Rescue, CABuilt 1985 · S/N 24-1535N21200Paramus Flying Club Inc · Fairfield, NJBuilt 2005 · S/N 18281732N21201Delta Aviation Inc · Monticello, MNBuilt 1972 · S/N 18261481N21202Diamond David Samuel Trustee · Truckee, CABuilt 1972 · S/N 18261482N21203Provence Michael D · Fort Worth, TXS/N 18261483N21205Hodl Partners LLC · Allen, TXBuilt 1972 · S/N 18261485N21206Baird David W · Kanab, UTBuilt 1972 · S/N 18261486N21207Jerdee Jonathan E · Moorhead, MNS/N 18261487N2120FWare Brandie W · Nikiski, AKS/N U206-0320N2120GSouthern Arizona Balloons Inc · Tucson, AZBuilt 1958 · S/N 51420N2120LN2120l LLC · Kansas City, MOBuilt 1976 · S/N TC-1985N2120ROda Mark E · Angola, INBuilt 1964 · S/N 18255320N2120XGolberg Companies Inc · Garfield, MNBuilt 1996 · S/N 29-0103N2120ZHenry John M · Anchorage, AKBuilt 1963 · S/N 18051220N21212Sale Reported · Phoenix, AZSale reported, canceledBuilt 2007 · S/N 172S10441N21215Van Steenkist Grant · Spokane Valley, WABuilt 1972 · S/N 18261494N21218Street Raymond E Jr Trustee · Palmer, AKBuilt 1976 · S/N 18503051N21219Dubose Brian · West YorkshireBuilt 1972 · S/N 18261498N2121FSouth Dakota State University · Brookings, SDBuilt 2007 · S/N 172S10437N2121GSutton Aircraft Salvage LLC · Palmer, AKBuilt 1958 · S/N 51421N2121LDl Contractors Inc · Rexburg, IDBuilt 1964 · S/N 18255370N2121RDengler Phillip L · Bordentown, NJBuilt 1964 · S/N 18255321N2121SGreat Bay Aviation LLC · Spring Hill, FLBuilt 1997 · S/N 29-0106N2121TSiebols Johan · Friendswood, TXS/N AA5B-1031N2121UBurk Timothy R Trustee · Ramona, CABuilt 1989 · S/N BW002N2121WSambell Warren D · Arlington, TXBuilt 1973 · S/N M1493N2121XTaylor Commercial Properties LLC · Jackson, TNBuilt 2004 · S/N 18281480N2121ZRegistered aircraftS/N 18051221N21224Registration Pending · Brenham, TXRegistration pendingBuilt 1972 · S/N 18261499N21227Fly21227 LLC · Charleston, WVBuilt 1972 · S/N 18261500N21228Atp Aircraft 4 LLC · Wilmington, DEBuilt 1978 · S/N 44-7995043N2122DS/S Systems LLC · Roca, NEBuilt 2016 · S/N 40914N2122GDavid Mieding Trustee · Reno, NVBuilt 1978 · S/N 32R-7985055N2122JCharles City Aeronautics Inc · Charles City, IABuilt 1978 · S/N 28-7916199N2122KKnight Paul · Kawkawlin, MIBuilt 2024 · S/N 2024PKN2122LWare Pat · Farwell, TXFirst renewal noticeBuilt 1978 · S/N 28-7990257N2122MHalsted Aviation LLC · West Chicago, ILBuilt 2007 · S/N 172S10442N2122NOwen Jason Ryan · Fort Irwin, CABuilt 1979 · S/N 28R-7918039N2122RAdventure North Flying Service LLC · Aitkin, MNS/N 28-5464N2122SBobo Construction LLC · Pullman, WABuilt 1975 · S/N 21061084N2122UAnderson Aerial Spraying Service Inc · Canby, MNBuilt 1970 · S/N 18800672N2122WRegistration Pending · Ubly, MIRegistration pending, pending cancellationS/N M-1495N21230Beggs Construction Inc · Salem, ORBuilt 1972 · S/N 18261502
Back to AD 2007-04-19 R1