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.

N169GRBlue Skies Above LLC · Spring, TXBuilt 1995 · S/N EA-580N169GSScott Gary L · Kings Beach, CABuilt 2022 · S/N 1165169N169HWood Wendell · Holland, TXBuilt 2001 · S/N 29-0264N169HCButterfly Wings Of Miami LLC · Miramar, FLBuilt 1973 · S/N 17262693N169JABixby & Sons LLC · Vale, ORBuilt 1964 · S/N 18256004N169JMBravo Alpha LLC · Driggs, IDBuilt 1978 · S/N P21000169N169JPBoggs Mitchell · La Russell, MOBuilt 1972 · S/N 28R-7235262N169JRHull Terri L · Weirsdale, FLBuilt 2010 · S/N 24081N169KD182 Flight Corp · Bronx, NYBuilt 1979 · S/N 18267456N169KSSvetfur Aviation LLC · Camden, SCBuilt 1978 · S/N 414A0015N169LALee Arnold Management Services Inc · Clearwater, FLBuilt 2017 · S/N TH-2494N169LHFarmingdale State College · Farmingdale, NYBuilt 2020 · S/N 2881375N169LPLcc East LLC · Freehold, NJBuilt 1999 · S/N 172S8234N169MGeorge Michael · Springfield, ILBuilt 1996 · S/N 034N169MECc Aviation Inc · Tracy, CABuilt 2000 · S/N 172S8449N169MJPlane Metrics LLC · Fort Worth, TXBuilt 2011 · S/N 80501N169NMaxfield Douglas · Chico, CABuilt 1962 · S/N 18051138N169PGHarty Joshua · Strasburg, COS/N T210-0423N169PXXing Kong Aviation Service LLC · Atwater, CAS/N 17281404N169RRGerlach & Associates LLC · Valparaiso, INBuilt 1979 · S/N TH-999N169RVFoster John O Jr · Hillsboro, ORBuilt 2013 · S/N 90574N169SHEaa Aviation Foundation Inc · Oshkosh, WIS/N 0169N169SPVahedi Vafa S · San Diego, CAS/N TC-353N169SUSouthern Utah University · Cedar City, UTBuilt 2011 · S/N 13146N169TSkybolt 3 LLC · Arvada, COBuilt 1973 · S/N T-1N169TFStewart Scott A · Anchorage, AKS/N 185-0383N169TRParker Timothy N · Socorro, NMS/N 169N169TSKestrelx LLC · Lake Mary, FLS/N 1694N169WHNoble John E · New Kent, VABuilt 2004 · S/N JC10N169XTalos Aeronautics LLC · Marion, TXBuilt 1993 · S/N 001N16AHendrix Aviation LLC · Benton, ARBuilt 1978 · S/N R18200405N16AEKessler Samuel A · Cave Creek, AZBuilt 1984 · S/N 1470N16AKGriffin Steven M · Enterprise, ALS/N 28R-7918057N16AMAnimal Health Supply Inc · Vinita, OKBuilt 1968 · S/N 30-1693N16AUTulsa Air And Space Museum Inc · Tulsa, OKS/N 002N16AVRanzenbach Edward · Albemarle, NCBuilt 2013 · S/N 2N16AWFreas Joseph R · Simi Valley, CABuilt 1973 · S/N 74-30634N16AXKing Austin · Abilene, TXBuilt 1980 · S/N 21064101N16BBEuroair Consultants LLC · Vero Beach, FLFirst renewal noticeBuilt 1974 · S/N TC-1749N16BDLambert Thomas E · Roland, IABuilt 1969 · S/N MB-456N16BJMarshall John Robert · Missouri City, TXBuilt 1979 · S/N 32R-7987115N16BKWc Aviation LLC · Forest, VABuilt 2012 · S/N TH-2335N16CBBoecher Carl A · Morrison, COBuilt 2018 · S/N 72745N16CJRoyale Air Service Inc · Fort Myers, FLS/N U20602501N16CRHoughton Thomas J · Preston, CTBuilt 1974 · S/N AA5-0679N16DADonaire Aviation LLC · Tampa, FLBuilt 1974 · S/N TH-501N16DBDivan Richard W · Wautoma, WIBuilt 1969 · S/N 17258618N16DLLincoln David · Henderson, NVBuilt 2022 · S/N 1310N16DMBordonaro Dominic L · Stratford, CTBuilt 1962 · S/N 23-1157N16DPNdmi Inc · Greeneville, TNS/N 24-3024
Back to AD 2007-04-19 R1