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.
N917ZWRealmark Ovation Rv10 LLC · Cape Coral, FLN9180TMcguire Michael D · Lake Stevens, WAN91813Fallbrook Fly Girl LLC · Lakeside, ORN9181CFord Winston · Tyrone, GAN9181DBoehmer Transportation Corporation · Machias, NYN9181EDonnelly Thomas G · Seattle, WAN9181PNorthwestern Michigan College · Traverse City, MIN9181SFhs Aero Co Ltd · Olathe, KSN9181WSkyward Horizons LLC · Maumelle, ARN91823Perra John James Trustee · Gardnerville, NVN9182AAlpha Aviation Holdings Group LLC · Raleigh, NCN9182HMouton Charles · Gladewater, TXN9182JTremblay Christopher A · Albion, MEN9182KRoth Howard R · Mott, NDN9182QFox Terrier LLC · Wilmington, DEN9182SBig Bend Community College · Moses Lake, WAN9182TShortridge Randall R · Mesa, AZN9182WMoyer Aviation Inc · Tobyhanna, PAN91834Skylink Xpress Inc · San Bernardino, CAN9183KKoinzan Flying Service Inc · Elgin, NEN9183SToole William Barry · Goochland, VAN9183VBerrong Jimmy L · Dahlonega, GAN9184LKindred Champ LLC · Hickson, NDN9184VCloud Distributing LLC · Austin, TXN91853Eminess Group LLC · Bradenton, FLN91854Sjostedt Brad D · Cordova, AKN9185HFlyit LLC · Washougal, WAN9185JRatcliff Dale A · Granville, OHN9185LKnighten Ammon J · Gakona, AKN9185SGrushkin Jon S · Mazon, ILN9185WFixed Gear Aviation LLC · Eldersburg, MDN91862Aire Services LLC · Barrigada, GUN9186DEckels Daniel R · Centerburg, OHN9186KMock Joseph R · Huntsville, TXN9186LAshby Darrell T · Elko, MNN9186MBlazer Aviation LLC · Charlotte, NCN9186SHigh Flyin LLC · Canton, MSN9186XRohrbaugh John M Jr · Warrenton, VAN9187CKd3262 LLC · Downers Grove, ILN9187LGardner James Jr · El Campo, TXN9187MPhillips Tim · Blair, OKN9187RMih LLC · Birmingham, ALN9187SCarr Gary · Crestwood, ILN9188GAircraft Management Services Inc · Milton, FLN9188JBooth Emmett W · Waitsburg, WAN9188LSodowsky Jim L · Ponca City, OKN9188SVanommeren Matthew · Uniondale, NYN9188TArizona Soaring Inc · Maricopa, AZN9188VValiair Limited Co Trustee · Casper, WYN9188WDc Engineering Inc · Meridian, ID
Back to AD 81-18-04 R2