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.
N77567Heiman Family Management LLC · Irvine, CAN7756BPeters Bruce G · Bakersfield, CAN7756DFalley Leighan T · Talkeetna, AKN7756HLarkin Marion J · Salome, AZN7756NSiegler Dylan Benjamin · San Mateo, CAN7756P56pop LLC · Fremont, OHN7756ZBoomer Aviation Inc · Fort Walton Beach, FLN7757NArmbruster Paul A · North Ridgeville, OHN7757ZMinden Soaring Club Inc · Minden, NVN7758GGallo Enterprises Inc · Wonder Lake, ILN7758HDillon John · Waitsfield, VTN7758PSkalsky Todd A · Hartley, TXN7758YMead Aviation LLC · Missoula, MTN7759APrange David H · New Palestine, INN7759DVezina Robert J · Rockford, MIN7759WGoedecke Chris A · Whitesboro, TXN775ACPittman Discover Flight LLC · Oshkosh, WIN775BDenning Todd E · Keenesburg, CON775CPCivil Air Patrol · Maxwell Afb, ALN775DHWheels Down Aviation LLC · Goshen, NYN775EESouthern Aircraft Consultancy Inc Trustee · Casper, WYN775GParagon Flight Training Co · Fort Myers, FLN775GACougar Leasing LLC · Everett, WAN775GTToole Gregory Keith · Humble, TXN775JPWentworth Philip C II · Nashport, OHN775KRRaczkowski Thomas F · Sacramento, CAN775KTPrijatel Thomas J · Cordova, AKN775LAColumbia Leasing LLC · Hillsboro, ORN775MCAmerican Patrols Inc · Midland, TXN775MSSkinner Leasing LLC · Medford, ORN775NDUniversity Of North Dakota · Grand Forks, NDN775PCMsb Aircraft LLC · Statesboro, GAN775PPAims Community College · Greeley, CON775RBBrewer George F II · Colorado Springs, CON775RHWuarin Jean Pierre · Pueblo, CON775RVLee Dean W · Saratoga Springs, UTN775SFN775sf LLC · Carthage, NCN775SP775sp LLC · Blaine, MNN775TAPrice Jeffrey R · Durand, ILN775VKoewler Stephen T · Sacramento, CAN775WBSusanville Aviation LLC · Susanville, CAN775XHurst Thomas W · Broken Arrow, OKN7760GLeriche Nicolette · Oceanside, NYN7760KGleason Thomas K · Sedalia, MON7760MBirdy Aviation LLC · Santa Barbara, CAN7761BTimblin Joel R · Boyceville, WIN7761DState Of Alaska · Fairbanks, AKN7761NRutter Matthew T · Arcadia, OHN7761YBytes Aviation LLC · Poolesville, MDN7762MMunn Kevin · Jeffersonville, IN
Back to AD 81-18-04 R2