AD 87-10-06 R1

Registered aircraft · 72,010

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:87-10-06-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:87-10-06-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.

N9272YIal Corp · Lewes, DEBuilt 1984 · S/N 31P-8414039N92731Plane@Work LLC · Blaine, MNBuilt 1946 · S/N 12-167N9273BAll-In Aviation LLC · Fort Myers, FLBuilt 1996 · S/N 3246035N9273JWhite Raymond · Jasper, ARBuilt 1966 · S/N 28-3351N9273PNormark Nancy B · Weirsdale, FLBuilt 1972 · S/N 18-8994N9273SYonly 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 248N92743Dulles Aviation Inc · Bristow, VABuilt 1997 · S/N 4496014N92747Wiles Donald · Shrewsbury, MABuilt 1973 · S/N 17261613N9274DBlatter 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 2844008N9274PMurray John F · Crystal Lake, ILBuilt 1968 · S/N 24-4774N9274QTen 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-8616020N92753Mccollum J R · Mount Pleasant, TXBuilt 1973 · S/N 17261614N9275JLow Country Flight Company LLC · Savannah, GAS/N 28-3353N9275SCole Larry G · Pigeon Forge, TNBuilt 1976 · S/N M-1763N9275VBridges Linda Arnett · Friendswood, TXBuilt 1969 · S/N 690076N9275XBarrakuda Ltd · Bend, ORBuilt 1996 · S/N 3246041N92765N92765 Inc Trustee · Wilmington, DEBuilt 1996 · S/N 4636070N9276CRegistration Pending · Kissimmee, FLRegistration pending, pending cancellationBuilt 1978 · S/N 28-7816454N9276DGilstrap Mathew W · Cotopaxi, COBuilt 1958 · S/N 18-6579N9276PHansen Stephen J · Redmond, WAS/N 24-4776N9276SMoody Daniel F · Lafayette, LABuilt 1976 · S/N M-1764N9276VBlair Jason C · Elbert, COS/N 690062N9276WWhitmire Matthew K · Artesia, NMBuilt 1968 · S/N 28-10950N92777Macatawa 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 17266065N9277MHodde James C · Mckinney, TXBuilt 1966 · S/N 3462N9277VAoa 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-227N92789N5746u LLC · Dover, DES/N 17261619N9278JMcbride Gary J · Niantic, CTBuilt 1966 · S/N 28-3357N9278MIlya Sevrugin · Santa Clarita, CABuilt 1966 · S/N 1215N9278SSpeed Kenneth W · Redington Shores, FLBuilt 1976 · S/N M-1765N9278WN9278w LLC · Corona, CABuilt 1967 · S/N 28-10952N92790Smith Aviation LLC · Springer, OKBuilt 1946 · S/N 12-236N92793Mikkelsen Caleb M · Wasilla, AKBuilt 1946 · S/N 12-239N9279DAcw Aviation LLC · Hines, ORS/N 18-6582
Back to AD 87-10-06 R1