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.
N9481DBoemig Madison K · Dalton, NHN9481JRuffner Samuel D · Powder Springs, GAN9481KHepp Investments LLC · Warrens, WIN9481NKing Cindy · Purvis, MSN9481VStutzman Mervin · Kingman, INN9481WMcintyre Stephen C · Lumberton, NCN94822Elon Aviation LLC · Burlington, NCN94823Black Hills Information Security Inc · Bozeman, MTN94825Vaughan Aviation LLC · Leesburg, VAN9482CSchuetz Ray · Davie, FLN9482DHanley Company LLC · Littleton, CON9482TReid John · Emmett, IDN9482WCantrall Aviation Flying Club LLC · Elizabethtown, KYN9482ZChristiansen Aviation LLC · Wilmington, DEN9483CCnczilla Co · Royersford, PAN9483TLindley Mark E · Wakefield, RIN9483VScholls Arnold W · Syosset, NYN9483WFlying D Aviation Of Kansas LLC · Wichita, KSN9484HN9484h LLC · Wheeling, ILN9484KDoll Electric Co Inc · South Lake Tahoe, CAN9484LHarrington Paul J · Queen Creek, AZN9484NBourjeili Elias · Glendora, CAN9484VHannon Fredrick W · Punta Gorda, FLN9485FGonzales David M · Corvallis, ORN9485JBlakely Jerry II · Coeur D Alene, IDN9485LRoll George N · Freeport, FLN9485VBrown Douglas B · Petaluma, CAN9486BMccoy Robert P · Fairbanks, AKN9486CRhodes Ryan · Dallas, TXN9486JJames Andy K · Shallowater, TXN9486KAerial Avionics Inc · Modesto, CAN9486NRahimi Navid B · Silver Spring, MDN9487JElmenhurst Daniel D · Walla Walla, WAN9487KInverted Air LLC · Mesa, AZN9487RBoyer Air Lc · West Des Moines, IAN9487WPikes Peak Fliers LLC · Colorado Springs, CON9488DClear Prop Aviation LLC · Sioux City, IAN9488GTap Solutions Inc · San Diego, CAN9488JSneed Associates LLC · Fort Morgan, CON9488VMarlow Michael L · Bandera, TXN94891Avcorp Holdings Inc · Jackson, MIN9489FHensley Richard · Bertram, TXN9489JIndiana County Flying Club Inc · Blairsville, PAN9489LFord John C · Norman, OKN9489VReeder John Galen · Cedar Falls, IAN948CBSouth Plains Implement Ltd · Seminole, TXN948CPCivil Air Patrol · Maxwell Afb, ALN948DBBoard David N · Moundsville, WVN948JTThompson James L · Thousand Oaks, CAN948PWEagles Soar LLC · Lewes, DE
Back to AD 81-18-04 R2