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.
N4200Burdick Rich · Montrose, CON42007Southeastern Oklahoma State University · Durant, OKN4200BCondair Flyers Inc · Latham, NYN4200HFoss David K · Anchorage, AKN4200MGrald Jonathan A · New Hampton, NYN4200XLeazer Johnathon E · Ozark, ALN4200YTexas Red Bird LLC · Palo Pinto, TXN42013Flynn Aviation LLC · Girdwood, AKN4201HWattenbarger Jay K · Fairbanks, AKN4201JYoerg Keith W · Culver City, CAN4201LSuverkrup Mark · Columbus, INN4201QReeve Ryan · Hurricane, UTN4201UEclipse Air LLC · Versailles, MON4201XWilson Daniel L · Sparta, MIN4201ZBennett Ruth B Trustee · Vancouver, WAN42024White Wings Air Inc · Jacksonville, FLN4202JParker Aviation LLC · Camdenton, MON4202LAa-Aero LLC · Fairfield, NJN4202PWells John · Eugene, ORN4202QWings Over Texas Holdings LLC · Denton, TXN4202TSexton Ronnie K · Clarksville, ARN4202XIzzy Air LLC · Madison, WIN4202YAll Sports Aviation LLC · Cocolalla, IDN4202ZPiatt Matthew D · Wasilla, AKN42033State Of Alaska · Anchorage, AKN42034Mueller Craig S · Bellaire, TXN42035Paulsen Hans J · Cedartown, GAN4203HIvy Mark A · Anchorage, AKN4203MLangenberg Stewart M · Santa Barbara, CAN4203PHillsboro Aero Academy LLC · Hillsboro, ORN4203QWings Over Texas Holdings LLC · Denton, TXN4203ZLongboat Key Aviation LLC · Wooster, OHN4204HAndrews Billy G · Wasilla, AKN4204YCharles Tim W · Caldwell, IDN4204ZKansas Air LLC · Linn, KSN42052Jaton Brady Glen · Sioux Falls, SDN4205HSwift Leonard M · Goldendale, WAN4205NRutherford Thom J · Burchwood, WIN4205TPoulsen Carlton Jr · Bossier City, LAN4205YDrobshoff Alex · Livermore, CAN42061Muhle Gerald A · Lincoln, NEN42062Parker Jo K Trustee · Ardmore, OKN4206HLeonard James P · Eagle River, AKN4206JRegistration Pending · Linn, MORegistration pendingN4206QOsmonovich Michael · Kent, WAN4206TTownsend Rhett · Manakin Sabot, VAN4207EDohnke Frederick William · Tehachapi, CAN4207HGage Duane · Princeton, IDN4207MLessley Aviation LLC · Carrollton, MSN4207TMisiura Edward Stanley Trustee · Elmhurst, NY
Back to AD 90-04-06 R1