AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N7755PBubak Land And Cattle LLC · Imperial, NEN77567Heiman Family Management LLC · Irvine, CAN7756BPeters Bruce G · Bakersfield, CAN7756DFalley Leighan T · Talkeetna, AKN7756HLarkin Marion J · Salome, AZN7756NSiegler Dylan Benjamin · San Mateo, CAN7757NArmbruster Paul A · North Ridgeville, OHN7758GGallo Enterprises Inc · Wonder Lake, ILN7758HDillon John · Waitsfield, VTN7758YMead Aviation LLC · Missoula, MTN7759APrange David H · New Palestine, INN7759DVezina Robert J · Rockford, MIN7759WGoedecke Chris A · Whitesboro, TXN775ACPittman Discover Flight LLC · Oshkosh, WIN775EESouthern 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, AKN775MCAmerican Patrols Inc · Midland, TXN775NDUniversity 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, UTN775SP775sp LLC · Blaine, MNN775TAPrice Jeffrey R · Durand, ILN775VKoewler Stephen T · Sacramento, 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, INN7762NRegistered aircraftN7762WHenson Russell K · Santa Fe, NMN7763HBrown F Wilson · Bedford, VAN7763MZimmerman Kurt L · Blacksburg, VAN7763NWever Marcus L · Lincolnton, NCN7763PRegistered aircraftN7763WSanchez Alyse Marie · San Antonio, TXN7764Reeves Mark S · Baldwinsville, NYN7764DHorn Bruce D Trustee · Zephyr Cove, NVN7764GTriad Aviation Academy LLC · Greensboro, NC
Back to AD 90-04-06 R1