AD 90-04-06 R1
Registered aircraft · 68,369
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.
N26551Havis Rex V · Crowley, TXN26554Taylor Kenneth R · Seminole, OKN2655MRenneke Wiest Lynnette E · Le Sueur, MNN2656GAtp Aircraft 4 LLC · Wilmington, DEN2656MHaggstrom Daryl V · Fairbanks, AKN2656TCardinal Point Aviation Services LLC · Homestead, FLN2656ZChesebro Brian S · Oro Valley, AZN26576Werbelow Brothers Partnership · Greybull, WYN2657BHughes Coby D · Collinsville, OKN2657MCurtis Christopher J · Wasilla, AKN2657WRegistered aircraftN2658TLoer Stanley W · Grants Pass, ORN2658WPerez Dennys · Orlando, FLN2659WMooney Flyer LLC · Belton, SCN2659ZWings Over Texas Holdings LLC · Denton, TXN265AAWhitten Chris K · Alton, MON265ACMorgan Nigel · Asheville, NCN265ATAirline Transport Professionals Corp Of USA · Wilmington, DEN265BHillestad Darrell · Aberdeen, SDN265BSGrant Charles K · Topton, NCN265CAZacherl Randall L · Indiana, PAN265ERAerosolutions Group Inc · Wilmington, DEN265FAStratus Rr LLC · New Castle, DEN265HBBarrow Guy J · Loveland, CON265MATrevathan Max Tyler · Braggadocio, MON265MGGeorgia Aviation Authority · Eastman, GAN265MHHarrington Michael · Twin Falls, IDN265NDAri Ben Aviator Inc · Fort Pierce, FLN265RMMccullough Carol Charlene Trustee · Tulsa, OKN265TWYale Companies LLC DBA · Indianapolis, INN265WGelinas Peter L · Burien, WAN26602Eastern New Mexico University - Roswell · Roswell, NMN2660AN62689 Inc · Texarkana, TXN2660PAnderson William B · Rogers, ARN2660QSummit Aviation LLC · Spokane, WAN2660WDeptula John R · Pinehurst, NCN26619Sides Michael E · Bartley, NEN2661TSix One Tango LLC · Pismo Beach, CAN2662TPlane Aviation LLC · Camarillo, CAN2662VPeck Kim O · Bolton, MAN2662WEaton Mark E · Houston, TXN26630Iasco Flight Training Inc · Redding, CAN2663JN2663j LLC · Rehoboth Beach, DEN2663PHoffrage Michael B · Fresno, CAN2663XAvolant Aviation LLC · Mooresville, NCN2663ZVaccaro Glen J · Trinidad, CON26645Morton Marvin E · Cambridge Springs, PAN2664AZmuda Bruce V · Eagle River, AKN2664KPeters Jeremy D · Nampa, IDN2664VKeaveny Kelly J · Annandale, MN
Back to AD 90-04-06 R1