AD 81-18-04 R2

Registered aircraft · 81,733

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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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.

N9273SYonly Abner Wanah · California, MDS/N M-1759N9273VLfc Solutions LLC · San Antonio, TXBuilt 1996 · S/N 3246036N9273WWhite J David · Louisville, KYBuilt 1967 · S/N 28-10946N9274Just Right Solutions LLC · Negaunee, MIS/N 248N92740Sandstrom David E · Anchorage, AKS/N 12-177N92742Graber Paul E · Brooksville, MSBuilt 1946 · S/N 12-180N92743Dulles Aviation Inc · Bristow, VABuilt 1997 · S/N 4496014N92747Wiles Donald · Shrewsbury, MABuilt 1973 · S/N 17261613N92748Mullins Esten R · El Paso, TXS/N 12-186N9274DBlatter Leland L · Hamilton, MTBuilt 1958 · S/N 18-6577N9274HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266062N9274JLund Christian W · New Ipswich, NHBuilt 1966 · S/N 28-3352N9274MGibson Rodney A · Saluda, NCBuilt 1966 · S/N 1213N9274NOkuda Hideki · Rncho Pls Vrd, CABuilt 1996 · S/N 2844008N9274QTen Hi Flyers Inc · Denver, COBuilt 1996 · S/N 3246038N9274WSkubisz Jozef H · New Lenox, ILBuilt 1967 · S/N 28-10947N9274YFlight Club 502 Inc · Louisville, KYBuilt 1985 · S/N 28-8616020N92751Allred Gina D Administrator · Centre, ALBuilt 1946 · S/N 12-191N92752Posey Timothy L · Shirley, ARBuilt 1946 · S/N 12-193N92753Mccollum J R · Mount Pleasant, TXBuilt 1973 · S/N 17261614N92754Kenney Alexander P · Fayetteville, ARBuilt 1946 · S/N 12-195N9275JLow Country Flight Company LLC · Savannah, GAS/N 28-3353N9275LEn Productions LLC · Grand Rapids, MIS/N AA1A-0175N9275SCole Larry G · Pigeon Forge, TNBuilt 1976 · S/N M-1763N9275TMoore Joseph P · Stillwater, OKBuilt 1978 · S/N 38-78A0312N9275VBridges Linda Arnett · Friendswood, TXBuilt 1969 · S/N 690076N9275XBarrakuda Ltd · Bend, ORBuilt 1996 · S/N 3246041N92763Bump Jennifer P · King Salmon, AKBuilt 1946 · S/N 12-207N92769Aero Bear Aviation LLC · Atlanta, GABuilt 1946 · S/N 12-214N9276CRegistration Pending · Kissimmee, FLRegistration pending, pending cancellationBuilt 1978 · S/N 28-7816454N9276DGilstrap Mathew W · Cotopaxi, COBuilt 1958 · S/N 18-6579N9276LCueva Arturo A · Los Angeles, CABuilt 1971 · S/N AA1A-0176N9276SMoody Daniel F · Lafayette, LABuilt 1976 · S/N M-1764N9276VBlair Jason C · Elbert, COS/N 690062N9276WWhitmire Matthew K · Artesia, NMBuilt 1968 · S/N 28-10950N92772Skyward Aviation Enterprises LLC · Raleigh, NCBuilt 1946 · S/N 12-218N92774Anderson Paul D · Anchorage, AKBuilt 1946 · S/N 12-220N92775Rector Calvin C · Karlstad, MNBuilt 1946 · S/N 12-221N92777Macatawa Flyers Inc · Allegan, MIBuilt 1973 · S/N 17261616N92779Montana Land Properties LLC · Missoula, MTBuilt 1996 · S/N 3246047N9277BFishers Shop Inc · Xenia, OHBuilt 1996 · S/N 3246057N9277EThomason Kenneth L · Council, IDBuilt 1977 · S/N 7154CN9277FKrushefski Chet W · Cedar Park, TXBuilt 1996 · S/N 3246042N9277HChorman Spraying LLC · Milton, DEBuilt 1975 · S/N 17266065N9277LMoseley Warren C · Arlington, TXBuilt 1971 · S/N AA1A-0177N9277MHodde James C · Mckinney, TXBuilt 1966 · S/N 3462N9277TCrouse Dewayne O · Eagle River, AKBuilt 1946 · S/N 12-157N9277VAoa Aviation Service LLC · Waxhaw, NCBuilt 1969 · S/N 690077N9277WMountjoy Trevor Douglass · Carbondale, COBuilt 1967 · S/N 28-10951N92781Aircraft Marketing & Leasing LLC · Fairbanks, AKBuilt 1946 · S/N 12-227
Back to AD 81-18-04 R2