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.
N70562Jets To Helis LLC DBA · Chandler, AZN7056PSelf Melvin Lamar Jr · Greenwood, MSN7056QFleeman Joseph R · Lawrenceburg, TNN7056WEustace Daryl R · Scottsboro, ALN7057LTri County Rentals And Sales Inc · Chiefland, FLN7057QMindy Limited LLC · Muscatine, IAN7057RContreras Robert G · Norman, OKN7057WWatkins Travis · Haughton, LAN70583Bult Equipment LLC · Monee, ILN7058GDc Aerial Photos Inc · Fredericksburg, VAN7058JStaggs Jerry A · Weatherford, TXN7058KGiarusso Richard John · Carlisle, IAN7058RMoss Harold E II · Overland, MON7058WRoman Donald M Jr · New Middletown, OHN7059State Of Alaska Department Of Public Safety · Anchorage, AKN70597Rodriguez Hulises · Chula Vista, CAN7059DSmith Andrew W · Willow, AKN7059GFrank Todd E · Corsicana, TXN7059HFly In Helicopters LLC · Florence, SCN7059PProx Jonathan P · Enterprise, ALN7059SParker Helicopter LLC · Watsonville, CAN7059WMartin Gerard A · Boston, KYN7059YPhill-Air Inc · Dover, DEN705ABHart Aviation LLC · Emory, TXN705BCShaw Thomas B · Hobbs, NMN705BHKingfisher Air Inc · Kodiak, AKN705CACoast Flight Training And Management Inc · San Diego, CAN705CFStanbridge Dale · Phoenix, AZN705CGLewis Scott M · Youngstown, OHN705DBEbco Aviation Insurance LLC · New Bern, NCN705DCDoucette Patrick S · Malta, MTN705EFEverett Farr 182 LLC · Lewes, DEN705FGRidgeline Assets LLC · Wilmington, DEN705FLSue Christina Alicia · San Antonio, TXN705JAFrl Flying LLC · Seattle, WAN705LULiberty University · Lynchburg, VAN705MMLeon Marco M · Broadlands, VAN705NDUnd Aerospace Foundation · Grand Forks, NDN705NRState Of Minnesota · Grand Rapids, MNN705PKahre Ryan · Blaine, WAN705RStatewide Contract Services LLC · Lowell, ORN705RBYakubinis William J · Charlotte, NCN705RVDetour LLC · Las Vegas, NVN705SDPaul Wallner LLC · Missoula, MTN705SRNewell Ryan A · Canton, OHN705TPhillips Gerald D · Lansing, MIN705UChristiansen Aviation LLC · Wilmington, DEN705WHSky Craft LLC · Powell, OHN7060D3ird Dog Aircraft LLC · Billings, MTN7060KMaxson Lee V · Mesa, AZ
Back to AD 81-18-04 R2