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.
N767XRegistered aircraftN7680DHart Gary L · Fernwood, IDN7680FMag Avionics LLC · Woodlands, TXN7680GGulyash Michael J · Ukiah, CAN7680RPotter Steven R · Grapevine, TXN7680SHallsten Stephen B · Fairbanks, AKN7680WMearbell Kevin J · Niagara Falls, NYN7681GCompass Aviation Inc · Shelby, NCN7681SCawley Jeffrey W · Buckley, WAN7681YTaft Aviation LLC · Brookhaven, NYN7682DMckay Don · Soldotna, AKN7682HHumphrey Ronald D · Pace, FLN7682JAv Serv LLC · Dover, DEN7682MVan De Hei Mike · Pioneer, CAN7682RTrull Stephen G · Golden Valley, MNN7682WMcintosh Doyle · North Ogden, UTN7683DYellow Bird Inc · Doral, FLN7683FFisch David S · Leland, NCN7683GBalgoyen James T · Charlotte, MIN7683HNovember Alpha LLC · Dover, DEN7683KArne Blair · Carpenter, SDN7683SSzabolscky Stephen L · Remington, VAN7684DRegistration Pending · Destin, FLRegistration pendingN7684FLettunich Mitchell C · Newcastle, CAN7684HWellborn Ralph L · Kenai, AKN7684SStrehle Scott · Lewiston, IDN7685DMcdonnell Chris M · Naknek, AKN7685SHull Kevin G · Sadler, TXN7685YNehrbass Douglas J · Clarksville, TNN7686FBaremor Terry A · Brooklyn Park, MNN7686JCovic Craig A · Cordova, TNN7686WEcho Aviator LLC · Whitehouse, OHN7686YMontana Leasing Group LLC · Park City, UTN7687MMckown Kevin · Edgewood, NMN7687RTaylor Edward P Jr · Spanishburg, WVN7687SLynn Robert W · Independence, WVN7688CCable Bradley D · Indianapolis, INN7688DMiller Gregory B · Wasilla, AKN7688HHersrud John D · Wasilla, AKN7688JClapp Rollyn D · Volga, SDN7688LConsag LLC · Ainsworth, NEN7688RTrudeau Lemaster Productions · Woodland Hills, CAN7688SJohnson Brian G · Goodridge, MNN7688WBurns Joyce A · Sparta, MON7689GMerrihew Jerry R · Ashby, NEN7689RDelehant Edward J III · Keller, TXN7689YGitlow Stuart · Woonsocket, RIN768AMeridian Aircraft LLC · Wilmington, DEN768ACBowe Joseph E · Ocklawaha, FLN768AZStinker Air LLC · Reno, NV
Back to AD 90-04-06 R1