OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,428

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.

N1852HI Fly Stl LLC · Saint Louis, MOBuilt 1959 · S/N 35952N1852JHanneman Robert · Denver City, TXS/N 28-24289N1852PBennack George H · Lyford, TXBuilt 1955 · S/N 18-4101N1852RHartman Craig T Trustee · Chugiak, AKBuilt 1975 · S/N 18502567N1852SReg Aeronatics LLC · Bradenton, FLBuilt 1981 · S/N E-1923N1852WDavis Sean · Carlisle, IABuilt 1973 · S/N TH-329N1852XPhillips Lane · Dawson, TXBuilt 1965 · S/N 18255952N1853BAltius Aviation LLC · Syracuse, NYBuilt 1981 · S/N TC-2420N1853JSargent David W · Port Angeles, WABuilt 1968 · S/N 28-24290N1853PViersen Leonard J Trustee · Glennallen, AKBuilt 1955 · S/N 18-4117N1853QSend North · Anchorage, AKBuilt 1975 · S/N U20602943N1853WKozdron Henry · Harbor Beach, MIBuilt 1973 · S/N D-9477N18541Bender Jace Ef · Humphrey, NEFirst renewal noticeBuilt 1996 · S/N 0165NN1854FHarlan Bradley J · New Brighton, MNBuilt 1966 · S/N 21058754N1854JM & D Aviation 2019 LLC · Ocklawaha, FLBuilt 1968 · S/N 28-24292N1854KNelson Law Firm Pc · Billings, MTBuilt 1981 · S/N E-1927N1854RSellers William G III · Troy, ALBuilt 1982 · S/N TH-1345N1854VSchmitt Rudy · Brookshire, TXBuilt 1974 · S/N 17263771N1854WRona-B LLC · Scottsdale, AZBuilt 1981 · S/N EA-269N1854ZBargabos William M · Wasilla, AKS/N 2050054N1855JNicholson John · Sapulpa, OKS/N 28-24293N1855PBpdk LLC · Mason, MIBuilt 2018 · S/N 5493N1855S1855 Sierra LLC · Brighton, MIBuilt 1981 · S/N CE-980N1856EGv Air Inc · Medford, ORBuilt 1979 · S/N 310R1591N1856FCraig Marc · Mountain City, TXBuilt 1981 · S/N E-1931N1856HVieman John D · Owensville, MOBuilt 1959 · S/N 35956N1856JWood Dragon LLC · Portland, MEFirst renewal noticeBuilt 1968 · S/N 28-24294N1856LR J Fuselier & Associates LLC · Eunice, LABuilt 1976 · S/N D-9889N1856RRich Gary L · Anchorage, AKBuilt 1974 · S/N 18502571N1856XRobert Yost Enterprises · Saint Francis, KSBuilt 1964 · S/N 18255956N1856ZBromley Wayne B · Colwich, KSBuilt 1981 · S/N CE-977N18576Cardinal-Bird LLC · Melbourne, FLBuilt 1976 · S/N 17702543N1857JMulas Joseph Anthony · Chesterfield, VABuilt 1968 · S/N 28-24295N1857RNoetic Aviation LLC · Seattle, WABuilt 1978 · S/N R18200581N1857TDieck Michael John · Fayetteville, NCBuilt 1971 · S/N 28-7225006N1857VCare Central Inc · Minneapolis, MNS/N 17263772N1858FMurrin Frederick L · Greenville, PAS/N FM-88N1858JKoenig Darrell Lee · Sumter, SCS/N 13031N1858LAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N CE-646N1858PBaron N1858p LLC · Fresno, CABuilt 1981 · S/N TJ-372N1858SC C Air Corp · Lancaster, CABuilt 1998 · S/N SCHWERIN-17N1858XSalem Aero Club Inc · Bridgeton, NJBuilt 1964 · S/N 18255958N1858ZPairofminutes LLC · Marshville, NCS/N 205-0058N1859AAverett University · Danville, VABuilt 2022 · S/N 2881527N1859CHadley Aviation LLC · Kent, CTBuilt 1981 · S/N CE-986N1859FBaker Robert J · Ogema, MNBuilt 1966 · S/N 21058759N1859P1859p LLC · Fulton, MOBuilt 1982 · S/N E-1995N1859TPhil Harris Saddlery Inc · State Road, NCBuilt 1971 · S/N 28-7225009N1859UMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S9927N1859WDellarosa Brian David · Indianapolis, INBuilt 1973 · S/N D-9503
Back to AD 2007-04-19 R1