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.

N1215XCella Joseph · Sewell, NJBuilt 1963 · S/N 2618N12161Cessna 12161 LLC · Santa Rosa, CABuilt 1973 · S/N 17261851N12168Boardman Thomas M · Greenwich, NYBuilt 1973 · S/N 17261855N12169Hammond Donald L · Palmer, AKS/N 17261856N1216GNeel Aviation LLC · Lakeland, FLS/N 414-0653N1216LLynch Steven J · Harrisville, RIBuilt 1975 · S/N 719N1216MHayward Flying Club · Hayward, CABuilt 1975 · S/N 18264245N1216NDodson International Parts Inc · Rantoul, KSFirst renewal noticeBuilt 2003 · S/N 0549N1216TOlsen Christopher D · Bothell, WABuilt 1972 · S/N 28R-7235238N1217Pendley Rory G · Torrance, CABuilt 1955 · S/N 23-237N1217070 Leasing LLC · Englewood, COBuilt 1973 · S/N 17261857N12176Cardinal Wings Aviation LLC · Buckner, KYBuilt 1973 · S/N 17261860N1217EJohnston Jason · Chugiak, AKS/N 255-77N1217FUnited States Department Of Interior · Boise, IDBuilt 1975 · S/N 18502779N1217PHarrison Jeffrey · Benton, ARS/N 61P-0395-135N1217TSauer Roger A · Glenburn, NDBuilt 1972 · S/N 28R-7235239N1217XRanger Aviation Enterprises Inc · San Angelo, TXBuilt 1963 · S/N 187N1217ZZillmer Kenneth E · Ocklawaha, FLS/N CD-304N1218Nogle Charles H · Champaign, ILFirst renewal noticeBuilt 1956 · S/N BG-163N12180Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261864N12181Great Landings Aircraft LLC · Arlington, INS/N 17261865N12187Lowcountry Flight LLC · Johns Island, SCBuilt 1973 · S/N 17261870N12188Chantreau Philippe · Vancouver, WABuilt 1973 · S/N 17261871N12189Ozark Aviation LLC · Fayetteville, ARBuilt 1973 · S/N 17261872N1218EShibakov Alexander Y · Gainesboro, TNBuilt 1977 · S/N 324-77N1218GBarth George E · Port Orange, FLBuilt 2012 · S/N 25085N1218JWeeks Wesley J · Iowa Park, TXS/N 218N1218SSkyvibe Leasing LLC · Aurora, ORBuilt 2012 · S/N 172S11161N1218XSmith II Richard D · Luthersville, GABuilt 1963 · S/N 2621N1218ZHutsell James M · Miamisburg, OHBuilt 1961 · S/N D-6682N12192Jet & Rotor Aviation LLC · Sacramento, CABuilt 1973 · S/N 17261873N12194Miller Yochonon · Lakewood, NJBuilt 1973 · S/N 17261875N12196Jdr Services LLC · West Plains, MOBuilt 1973 · S/N 17261877N12197K Airmotive LLC · Saint Helens, ORBuilt 1973 · S/N 17261878N1219AFeltman Joshua C · Kenai, AKS/N 18-834N1219GRegistered aircraftBuilt 2007 · S/N 18281886N1219PJersey Christopher M · Willis, TXBuilt 1977 · S/N 18265701N1219TLrh Equipment LLC · Pendleton, ORBuilt 1972 · S/N 34-7250265N1219USouth Bay Flight Training Center · Carolina, PRBuilt 1976 · S/N 17266916N121AWhidby Richard L · Aynor, SCBuilt 1992 · S/N 2045N121AFEway William · Jupiter, FLBuilt 1981 · S/N TH-1254N121AHSoul Shine LLC · Nashville, TNBuilt 2004 · S/N 10548N121AMEastern Stearman Inc Trustee · Leesburg, VAS/N CE-1126N121ARGold Mountain LLC · Kalispell, MTBuilt 1979 · S/N 53N121AVPreece William F · Cheshire, CTBuilt 1984 · S/N 28-8490078N121BBFearon Terrence J · Whitehouse Station, NJBuilt 1963 · S/N 18-7908N121BCCavanaugh Collections Inc · Addison, TXS/N G-123N121BDKorn Air LLC · Fort Lauderdale, FLS/N 414A0297N121BEKrdm LLC · Fallon, NVS/N D-7920N121BKSeabee Training Corp · Birmingham, ALBuilt 1977 · S/N 310R0893
Back to AD 2007-04-19 R1