AD 84-10-01 R1
Registered aircraft · 20,483
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:84-10-01-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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.
N34271Globalsvc Aviation Group LLC · Coeur D Alene, IDN3427SNovember Sierra LLC · Lake Havasu City, AZN3427VHowker John A · Louisville, KYN3428FKcsi Aerial Patrol Inc · Bakersfield, CAN3428UHcp Aviation LLC · Waco, TXN342EAAfrican Inland Mission International · Peachtree City, GAN342MEAerostatics LLC · Gainesville, FLN342MMJohnson Aaron M · San Ramon, CAN342MWHolway Stephen M · Gainesville, FLN3430FWingeier Dairy Farms · Alto, MIN3430LDachniwsky Holdings LLC · Southlake, TXN3430SBlue Skai Aviators LLC · Lawton, OKN3431LJacobs Brittany Lyn · Seattle, WAN3431RGuibaud Albert G · Monrovia, CAN3431YMinor Joseph H · Hyannis, NEN3432FBierschwale Land Co LLC · Mason, TXN3433FVapor-Mist Sanitizing Systems · Boca Raton, FLN3433RAlty It Solutions LLC · Milan, MIN3433SKah Gretchen Wendel · San Francisco, CAN3434RBurkhardt James · Brookings, SDN3434SDawsey Carl E · Long Beach, MSN3434UHale William R · Covina, CAN3435FDickens Frank K · Moncure, NCN3435LYuknis Birch · Wasilla, AKN3435UJackson Terry W · Lewisburg, TNN3435VChieffo Robert · Poughquag, NYN3437FYankee Air LLC · Valdosta, GAN3437RSmith Darrin M · Torrance, CAN3437YLanding Gear Works LLC · Renton, WAN3438RDauenhauer Colby · Springtown, TXN3438UGrau Gary Wayne Jr · Yelm, WAN3439SProtsman Bryan D · Anchorage, AKN3439UFlycatcher Aviation LLC · Purcell, OKN343CACivil Air Patrol · Maxwell Afb, ALN343METhurman Craig Johnson · Ona, WVN3440SLynch Chris A · Sedro Woolley, WAN3440UPlane Joy LLC · Payson, AZN3440VBarrientos Jeri D · Collinsville, OKN3441FLawrence Kam M · Big Bear City, CAN3441LBarlow Dwight D · Monte Vista, CON3441RQualtieri John E · Fallon, NVN3441SSun Technology LLC · Cheyenne, WYN3441UDemeyer Scott M · Olympia, WAN3441YBird Avery L · Wasilla, AKN3442SRail Birds · Clearfield, UTN3442VAdams Richard J · Mesa, AZN3443RBertrand John E · Trion, GAN3443SWilliams Forest Chem LLC · Columbus, GAN3443UHall George K · Cathedral City, CAN3443VMenard Charles H · Burton, MI
Back to AD 84-10-01 R1