AD 90-06-03 R1
Registered aircraft · 20,687
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-06-03-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-06-03-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-06-03-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-06-03-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.
N9887VDarby Holly M · Midland, TXN98887Jodkin Jason · Confluence, PAN9888GRegistration Pending · Atlanta, TXRegistration pending, pending cancellationN9888JHoran Lawrence J · Terrell, TXN98893Pape Jason C · Sykesville, MDN9889GWright Flight Inc · Tucson, AZN9889QTack-Morse Patricia M · Sweet Home, ORN988BEN988be LLC · Manassas, VAN988BGMojo Flight Group LLC · Gainesville, GAN988CPCivil Air Patrol Inc · Maxwell Afb, ALN988WUBravo Whiskey Aviation LLC · Louisville, KYN98913Civil Air Patrol Inc · Maxwell Afb, ALN9891GOuellette Kevin E · Frederick, OKN9891TDunkley Bret Y · Kotzebue, AKN98923Costa Flying Service Inc · Painted Post, NYN9892GFritz John P · Belvidere, NJN9892QLytle Jack J · Omaha, NEN9893QDougherty Casey · Rock Island, WAN9894G1s6 Flying Club Inc · Sandpoint, IDN9894QKarpov Konstantin A Trustee · Fort Bragg, CAN98954Emerson Solutions LLC · Bellingham, WAN9895FRetro Modern Aviation LLC · Manitou Springs, CON9895GKellerman Roger B · Rockford, ILN9895QCk Leasing Services LLC · Wilmington, DEN9895VTogo Aviation Services LLC · Palmer, AKN98960Buiqui Aerospace Corp · Kissimmee, FLN9897FPinnacle Aviation Services Inc · Encinitas, CAN9897QAbove All Aviation Inc · Santa Barbara, CAN98981Airplane And Drone Flight Instruction LLC · Orlando, FLN98987Civil Air Patrol Inc · Maxwell Afb, ALN9898QSecond Wind Aviation Corp · Friday Harbor, WAN9898THumphress John A III · Campbellsville, KYN9899GWings Over Texas LLC · Denton, TXN9899QBrown Richard K · East Falmouth, MAN989CWCardinal Wings Aviation LLC · Buckner, KYN989SPJet Air Inc · Iowa City, IAN989WDTextron Aviation Employees Flying Club Inc · Wichita, KSN989WUEglin Aero Club · Eglin Afb, FLN98DXInternational Air Services Inc Trustee · Carson City, NVN98EMGreen Tool & Die Co LLC · Honesdale, PAN98FFPeregrine Howard Fund V Owner LLC · New Orleans, LAN98GCGarcia Alexandra · Pompano Beach, FLN98ZTSharp Paul A II · Apollo Beach, FLN9900QBedsole Clinton Allen · Frisco, TXN9902QBowers John E · Owasso, OKN9903VDwh Flight LLC · Spring, TXN99040Bradley Aircraft Company LLC · Columbus, INN99045Allen Michael R · Graham, NCN99048Bradley Aircraft Co · Columbus, INN9904QStanford Jay J · Saint Marys, GA
Back to AD 90-06-03 R1