AD 90-02-13
Registered aircraft · 3,863
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-02-13')
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-02-13')
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-02-13') 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-02-13') 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.
N310NZCo Fire Aviation Inc · Fort Morgan, CON310PERypien Andrew · Denver, NCN310PHFreeman Jet LLC · Cape Coral, FLN310PLBrooks James Milton · Pineville, KYN310PWWalton Lee W · Houston, TXN310QSlaughter Bradley R · Pilot Grove, MON310QBSierra Delta Aviation Services Inc · Middletown, DEN310QDHowell Charles N Jr · Cordova, TNN310RSky King Airplanes LLC · Lewes, DEN310RCFuchs Rolf G · Tavernier, FLN310RDSouthern Illinois University Board Of Trustee · Murphysboro, ILN310RLLaws James R · Gray, TNN310RMKeeton Andrew · Palestine, TXN310RRWateractive43 LLC · Auburn, CAN310RSSmith Richard S · Green Valley, AZN310SFGear Down Aviation LLC · Boynton Beach, FLN310SGFlorida Flyers Flight Academy Inc · Saint Augustine, FLN310SL336 Investments LLC · Sumrall, MSN310SRGilland Jonathan R · Elkton, TNN310STWorld Pilot Services LLC · Garland, TXN310SVFlairships LLC · Durham, NCN310TAW Ne Holdings LLC · Harrisburg, NEN310TCWalton Mark · Martinsburg, PAN310TGHupper Clifford E · Pelham, NHN310TJRegent Trust Corp Trustee · Wichita, KSN310TLRegistered aircraftN310TMMerritt Ricky T · Mesa, AZN310TPSouthern Arkansas University Tech · Camden, ARN310TSPro Aire Cargo & Consulting Inc · Oshkosh, WIN310TYSol Aerial Surveys LLC · Las Vegas, NVN310UDGorge Winds Aviation Inc · Fairview, ORN310UKInternational Air Services Inc Trustee · Carson City, NVN310VRound Trip Lc · Elkhart, KSN310VHVan Horn Jeffrey · Jonesboro, ARN310VRWg Aircraft Holding Corp · Daytona Beach, FLN310VVMsl Air Inc · Sugar Grove, ILN310WDHernandez Jr Raymond Trustee · Burleson, TXN310WGMunro Donald W · Commerce Township, MIN310WHLexington Air Services LLC · Greenwood, MSN310WPPardue William E · Fort Worth, TXN310WSN310ws LLC · Athens, ALN310WVHill Rick A · Bridgeport, WVN310XPFour Aces Montana LLC · Missoula, MTN310XRValiair Limited Co Trustee · Casper, WYN3110LYellowfin Aero LLC · Seminole, TXN3114LResendiz Marcelino · Alamo, TXN311BC311bc LLC · Channelview, TXN311BTBob Air LLC · Concord, MAN311CASouthern Wings LLC · Shreveport, LAN311GRPfeffer David D · Jacksonville, FL
Back to AD 90-02-13