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.
N75938Fiedler Aviation LLC · Suffolk, VAN7593EFrench Robert J · Ferndale, WAN7593HFricks Philip B · Piedmont, SCN7593RPiasecki Christopher Andrew · Lemont, ILN7593VBlanzy Paul J · Highland, MIN7593YEpic Aviation Leasing LLC · Puyallup, WAN75942Ward Sharon A · Lago Vista, TXN75943Savage Island Airport (Vt15) LLC · Burlington, VTN75944Noll Gregory Lloyd · Watford City, NDN7594FPierschbacher Clifton A · Marysville, WAN7594VSilly Boy Aviation LLC · Moses Lake, WAN75950West John T · Bulverde, TXN75955Belgarde Monte G · Butte, MTN75956Millennium Aviation Group LLC · Wallace, NCN7595EFlynn Andrew L · La Grande, ORN7595HKnutson Daniel T · Lodi, WIN7595JDykes Jeff · Riverside, WAN7595RTedeschi Steve · Irving, TXN7595W180 Inc · Shelby Township, MIN75967Ace Of Spades Aviation LLC · Las Vegas, NVN7596JN7596j LLC · Denver, CON7596RChocolaterie Ltd · Des Moines, IAN7596WSchaefer Hugh W · Merrick, NYN7596YRodgers Kevin M · Vacaville, CAN75971Price Ronald Anthony · Deer Park, WAN75972Aircraft Resource Center Inc · Lakeville, MNN75974733et LLC · Columbus, OHN75976Suburban Aircraft Leasing And Sales LLC · Sylvania, OHN7597FKnowles Ross Martin · Chapmanville, WVN7597KGuptill Patrick · Quinn, SDFirst renewal noticeN7597PSpinks Matthew Robert · Clarkesville, GAN7597RGarces Carlos A · Springfield, VAN7597VMulligan Shawn P · Santa Rosa, CAN75982Schurr Frank J · Las Vegas, NVN75985Pitt Patrick L · Ephrata, WAN7598FDoggett Jacob R · Kingwood, TXN7598GGbc Leasing LLC · Gun Barrel City, TXN7598JShutt Ervin F · Bennettsville, SCN7598PBurton Channing L · League City, TXN7598WSmith Cameron · Billings, MTN7599CHurd Air LLC · Sioux Falls, SDN7599FN7599f LLC · Camarillo, CAN7599GJones James D · Linden, NCN7599HMorris Sid · Kenai, AKN7599JZurro Roger M · Freehold, NJN7599KSimmons Dawson L Jr · Council, NCN7599RHoffman Harold O · Andrews, TXN759AKMichael Michael D · Soldotna, AKN759LBBrown Larry W · The Villages, FLN759STraining Planes LLC · Tampa, FL
Back to AD 90-04-06 R1