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.
N6080NHuberty Gregory N · Circle Pines, MNN6081HFlathers George William II · Palmyra, VAN6081NTamim Shekaib · Tracy, CAN6082NNewberg G Edward · Haines City, FLN6082QIrvine Brooklyn L · Sacramento, CAN6082VStewart Glen W III · Lebanon, TNN6083ABilton Aircraft Management Inc · Umatilla, FLN6083JB&R Aircraft LLC · Wadsworth, OHN6083LSorensen Paul E Jr · Los Lunas, NMN6083QAjirogi Michael T · Pearl City, HIN6083VScholz Francis M · Atchison, KSN6084CBig Bend Community College · Moses Lake, WAN6084DCsapos Larry G · Ovid, MIN6084MGrider Charles H III · Belleville, ILN6084NHilpertshauser David J · Sheboygan, WIN6084QHammond Edward M · Grass Valley, CAN6084RKdb Flying LLC · Branchville, SCN6085Old Sport Aviation LLC · Ranger, TXFirst renewal noticeN6085FAmeriflyers Of Texas Inc · Addison, TXN6085HKlingenberg Tim C · Udall, KSN6085LLevy Stanley · Arcadia, CAN6085MWood Mark D Trustee · New Berlin, WIN6085NShuffield Brian D · Oregon House, CAN6085SSkyline Soaring Club Inc · Front Royal, VAN6085XLight Richard S · Wichita, KSN6086GAbovestandard LLC · Denison, TXN6086UStearman Air Tours Inc · Gatesville, NCN6086WPegasus Ir LLC · Miami, FLN6087LSundsmo Sheldon L · Adams, WIN6087QTyson Michael A · Cupertino, CAN6087UN6087u LLC · Homestead, FLN6088DSale Reported · Langley, WASale reportedN6088LCollins Harold H · North Las Vegas, NVN6088QParker Justan · New Durham, NHN6088UPotter Timothy E · Murfreesboro, TNN60890White Edwin J · Avondale, PAN60895Donald Williamson · Piedmont, SDN6089DHoyt William C · Trimble, MON6089FAmeriflyers Of Texas Inc · Addison, TXN6089KDelta State University · Cleveland, MSN6089MAirplanes And Helicopters Of Oregon LLC · Sisters, ORN6089PMichaelsen Richard P · Sanborn, NYN6089QMolnar Victor · Ballston Spa, NYN608ACBas Part Sales LLC · Greeley, CON608AMEnalas Corp · Bayonne, NJN608DMMartens Dennis · Vermillion, SDN608DSJoerithan & Mp Aviation LLC · Whittier, CAN608EAKingsky Flight Academy LLC · Lakeland, FLN608FAStratus Rr LLC · New Castle, DEN608FMSouth Bay International Flight Association Inc · Torrance, CA
Back to AD 90-04-06 R1