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.
N9984CTucker Harry B · Lexington, NCN9984RMoloney Phillip M · Lexington, KYN9984VValley Drug Of Malta Inc · Malta, MTN9984WBlake David R · Sheridan, WYN9985BJacks Charles D · Morse, LAN9985DTrimmer Marvin E · Willow, AKN9986CLawrence Oakes K III · Newfields, NHN9986DWalsh Arthur B · Lincoln, NERegistration revokedN9986SKaneaster Richard W · Port Orange, FLN9988FDel Rio Aviation Inc · Paso Robles, CAFirst renewal noticeN9988RSanders Flight Training Center Inc · Jasper, ALN9988VLenoir Aviation Club Inc · Lenoir, NCFirst renewal noticeN9988WHanneman Michael W · Abilene, TXN9989VPace Dusty · Pendleton, ORN9989WDnr Solutions LLC · Idaho Falls, IDN998BHayton James B · Sedro Woolley, WAN998BCSky High Homes LLC · Etna, WYN998CCBecker Mike DBA · La Grande, ORN998CPCivil Air Patrol · Maxwell Afb, ALN998DMD & S Aviation LLC · Spring, TXN998DWSpartan Education LLC · Tulsa, OKN998FBRegistered aircraftAssigned, pending cancellationN998FGFlightgest Academy LLC · Morrisville, NCN998GMMcaviation Inc · Wilmington, DEN998KCenter Charles C · Wasilla, AKN998MAWarhawk LLC · Latrobe, PAN998MMHardcastle Eric · Holly Springs, NCN998NCHoppe Joel A · Fort Myers, FLN998PWBaker Toby J · Guthrie, OKN998RASchubert Brothers Aviation Inc · Canandaigua, NYN998SEUtter Albert · Fort Myers, FLN998TJJenkins Teal W · Buckeye, AZN998TMSky West Aviation Inc Trustee · Albuquerque, NMN998TTHunton Hugh R II · Midlothian, TXN998WPReifers Todd R · Indianapolis, INN998ZWeimer Andy A · Pierce, IDN9990BAurora-Flight LLC · Commerce Township, MIN9990CFogarty Stephen J · Wasilla, AKN9990VCompass Aviation Inc · Shelby, NCN99917Anderson Cody Jon · Orono, MEN9991BTaft Leasing LLC · Bloomfield, NMN9991DNothum Robert G · Dixon, MON9991GSale Reported · Staten Island, NYSale reported, canceledN9991LStory Norwood P Jr · Plano, TXN9991VSafeway Flying Club Inc · Denmark, WIN9992LLenz Lance J · Van, TXN9992VShipe Jacqueline M · Louisville, TNN9993DMunson Matthew C · Canby, ORN9993ECruise Flight Academy Inc · Dalton, GAN9993HCarlsfrom Thomas A · Bonita Springs, FL
Back to AD 81-18-04 R2