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.
N8710HHickman Air LLC · Black Oak, ARN8710YSmith Charles W · Savannah, GAN8712CCopp Perry T · Adin, CAN8712DRegistered aircraftN8712NCook Jeffery M · Lakewood, WAN8712VKnobloch Jack F · Birney, MTN8712YBurns William Robert · Niceville, FLN8713COlsen Crosby J · Bainbridge Island, WAN8713JWells Joel A · Corydon, IAN87140Cgl Media LLC · Jupiter, FLN8714DAzevedo Miguel · Trion, GAN8714FDown East Emergency Medicine Institute · Orono, MEN8714MCole Leonard O III · Sunrise Beach, MON8714NHatch Joseph B · Mesa, AZN8714SFisher Timothy S · Tucson, AZN8715CDarcy Aviation LLC · Danbury, CTN8715DKline Linda L · Fountain Hills, AZN8715NKenmore Crew Leasing Inc Trustee · Bellingham, WAN8716MWilliams Excavating Inc · Partlow, VAN8716NWeiss Ariel · Bisbee, AZN8717CBristow Leonard B · Damar, KSN8717VSepko Joseph M III · Mebane, NCN8717YParker Meyers And Roth Inc · Morgan Hill, CAN8718DSlaughter James M Jr · Houston, TXN8718MGilson David R · New Port Richey, FLN8718NKelly Bradford S · Bedford, NHN8718VBecker Chris H · Panama City, FLN8719FKinzie Wayne · Alva, OKN8719VBluemel Steve · Auburntown, TNN871ACAri Ben Aviator Inc · Fort Pierce, FLN871CCUeckert Russell N · Abilene, TXN871CGBunting Cameron E · Lake City, FLN871CPRedstone Arsenal Flying Activity · Redstone, ALN871DMId Air LLC · Apopka, FLN871FFunk Kevin A · Crescent City, FLN871MAN2634mm LLC · Farmingdale, NYN8720MHulme Aviation LLC · Gilbert, AZN8720NHogan David A · La Crosse, WIN8721NCobe Aviation LLC · Miller, SDN8721VEliasquevici Abrao · Ocala, FLN8722CMayhew Oliver C Jr · Blairs, VAN8722DWirthlin Donald K · Sierra Vista, AZN8722NKrueger Sandra J · Chicago, ILN8723COracle Aviation LLC · Omaha, NEN8723ECronk Howard J · Council Bluffs, IAN8723ZKnapp James A Trustee · Casa Grande, AZN8724Fairhope Decathalon LLC · Fairhope, ALN8724DMoe Daniel N · Mukilteo, WAN8724EDcs School Of Flying LLC · York, PAN8724FDel Rio Aviation Inc · Paso Robles, CA
Back to AD 90-04-06 R1