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.
N5197TUw Flying Club Inc · Sun Prairie, WIN5197ZPalmer Ralph Jr · Howard City, MIN5198EGaruda Flight Training LLC · Miami, FLN5198HBranson William E · Stokesdale, NCFirst renewal noticeN5198PBrooks Larry D · Ramona, OKN5198XCornwell Thomas G Jr · Eatonville, WAN51991Raider Aviation LLC · Lubbock, TXN51996Skywarrior Flight Training Inc · Pensacola, FLN5199LPrince Bros Aviation LLC · North Canton, OHN5199STacoma Sky LLC · Winston Salem, NCN5199TOwens Roger A · San Antonio, TXN5199XGallarate Raymond D · Sonoma, CAN5199ZLeister Tyler W · Norfolk, VAN519ALester John M · Okanogan, WAN519ACC & J Air Inc · Middletown, DEN519AFVee Two Inc · Merritt Island, FLN519DCLedet Erik C · Huxley, IAN519FLeonard William E · Vancouver, WAN519GPEmerald City Aircraft Leasing Inc · Port Orchard, WAN519HCain James W · Big Rapids, MIN519JLakeland Tower Leasing Co · Traverse City, MIN519JMWolfgang James · Milledgeville, GAN519JTJenkins Nicholas M · Los Osos, CAN519MARed Baron LLC · Middletown, DEN519QNewman C Keith · Cypress, TXN519RGRegistration Pending · Kokomo, INRegistration pendingN519THeritage Tx Enterprises LLC · Prosper, TXN519TCSchoepflin Robert Dennis · Palouse, WAN519WGThunderbird Photography LLC · Greenville, CAN51AANoble Caleb E D · Glennallen, AKN51AMKerns Joshua S · Leander, TXN51AWPreston Richard R Trustee · Albuquerque, NMN51BBOlivo Ashton Mars · Inwood, NYN51BJHancock Timothy C · Mansfield, MON51BPBravo Papa Flight Training LLC · Wichita Falls, TXN51BZBlock David V II · Heath, TXN51CBPukach Greg V · Topeka, KSN51CTLionudakis Chris L · Conroe, TXN51DGOrcas Aircraft LLC · Orcas, WAN51DUOkeefe William G · Grand Forks, NDN51EGGromala Eric M · Forestville, CAN51EHHolmgren Elizabeth · Pittsburgh, PAN51ERPlane Fun Inc Tr Trustee · Snellville, GAN51EVVan Bladeren Ronald W · Vancouver, WAN51EXJames Jonathan K · Stillwater, MNN51FLThomas Kenneth L · Eureka, MON51GTBowen Austin T · Prairie Township, NDN51HCVelarides Paul · Litchfield Park, AZN51HSGilbert Joe M · Sapulpa, OKN51HUTeton Aircraft Sales LLC · Jackson, WY
Back to AD 90-04-06 R1