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.
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
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.
N842LPJet Air Inc · Iowa City, IAN842MM43 Northstar LLC · Dodgeville, WIN842NDUnd Aerospace Foundation · Grand Forks, NDN842NEPringle Greg S · Sandy, UTN842PTTemple Peter L · Harrisville, NHN842RBLowcountry Flight LLC · Johns Island, SCN842SAJet Air Inc · Iowa City, IAN842SHSilver Star Helicopters LLC · El Campo, TXN842SPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN842SVPylon Aviation Services LLC · Chandler, AZN842TAkin Air LLC · Monticello, ARN842WSplit Oak Contracting Inc · Williamson, GAN84309Mcgee David · West Monroe, LAN8430DBottorff 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, KSN84338Jrh Wings LLC · Alva, OKN84339Burnt Pond Aero LLC · Ostrander, OHN8433LHeacock Jeffrey A · Hollis, MEN8433NBrickhaus David J · Weldon Spring, MON8433RRichards Riley · Seattle, WAN8433WKilduff James L · Wellsboro, PAN84342Choate 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, TX
Back to AD 81-18-04 R2