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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N842PWalker Vince · Boulder, CON842PTTemple Peter L · Harrisville, NHN842RBLowcountry Flight LLC · Johns Island, SCN842SHSilver Star Helicopters LLC · El Campo, TXN842SPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN842SVPylon Aviation Services LLC · Chandler, AZN842TAkin Air LLC · Monticello, ARN842TCWitte Transport LLC · West Plains, MON84309Mcgee David · West Monroe, LAN8430BTrident Aviation LLC · Bedford, NHN8430DBottorff Marshall B · Kimberling City, MON8430RRegistration Pending · Calera, OKRegistration pendingN8430WZuber Thomas P · Opelika, ALN8430YDavid Litteken · Aviston, ILN84316Smith Jimmy C · Plano, TXN84317Waco West Inc · Dover, DEN8431LDsr Cherokee 180 LLC · Dallas, TXN8431WAhearn Bernard Francis · Farmington, NHN8431YN8431y LLC · Coatesville, INN8432Himsl Vincent S · Mattawa, WAN84326Yang Edward E · Killeen, TXN8432BClaxton David R · Cookeville, TNN8432CEmpire Aviation · Oxford, NCN8432LAster Labs Inc · Shoreview, MNN8432WBinek Darwin P · Midlothian, TXN8432YTaylor Kyle F · Enterprise, ALN84330Blanche-Caron Elie P · Palmer, AKN84332Engler Jerry J · Kerrville, TXN84333Backup Enterprises LLC · Conway Springs, KSN84337Kent East Inc · Wilmington, DEN84338Jrh Wings LLC · Alva, OKN84339Burnt Pond Aero LLC · Ostrander, OHN8433AWoods Todd Ryan · Perry, OKN8433LHeacock Jeffrey A · Hollis, MEN8433RRichards Riley · Seattle, WAN8433WKilduff James L · Wellsboro, PAN8433YLomeli Rigoberto Orozco Jr · Longs, SCN84342Choate Aviation LLC · Summerville, SCN84346Registration Pending · New Derry, PARegistration pendingN84347Giovannini Marco · Malibu, CAN8434DAllen Clifford R · Indianapolis, INN8434EWiborg Eric J · Fort Lauderdale, FLN8434LMemmi Charles D · Three Springs, PAN8434RPeoples John R Jr · Hixson, TNN8434WAlpha-One Air Service LLC · Concord, NCN84350Piecko Michael T · Genoa, ILN84351Stanton James W · Maple, NCN84352Boundless Aviation LLC · Kailua Kona, HIN84358Child Michael A · Fort Worth, TXN8435DOrbis Advisory Services LLC · Hebron, KY
Back to AD 87-10-06 R1