AD 2011-18-51 R1
Registered aircraft · 785
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:2011-18-51-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:2011-18-51-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:2011-18-51-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:2011-18-51-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.
N700BAAviation Inventory Resources Inc · Alvarado, TXN700DALowrey Jonathan S · Jasper, INN700WAJohnson William M · Wichita, KSN7065DValley Air Service · Caldwell, IDN708PCAustin Point Aviation LLC · Portland, ORN709TRAmeriflight LLC · Dfw Airport, TXN70PEGst Aviation LLC · Tucson, AZN70WYBecker Flying Service Inc · Hartington, NEN710RSArmstrong Brad A · Tyler, TXN711MBBarrick Gold Of North America Inc · Henderson, NVN711VKDuggar Aviation LLC · Tontitown, ARN716CCRichmond Wheeler LLC · Marshfield, WIN716SMConquest Flight LLC · Pottstown, PAN718EEN718ee LLC · Missoula, MTN7222FGriffin Aviation LLC · Great Falls, VAN725JTCorsair Enterprises Inc · Wilmington, DEN725SVTtc Aircraft Leasing Inc · Decatur, TXN727DPTvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTN727TPAudubon Air Of Louisiana LLC · Bossier City, LAN728FNAustin Bill DBA · Sparta, TNN731EAlaskan Air Charter LLC · Anchorage, AKN731TFTwo Friends Leasing LLC · Key West, FLN733BHCareer Aviation Company Inc · Wilmington, DEN741FNAir 1st Aviation Co Of Ok · Tulsa, OKN746KAKolob Canyons Air Services Inc · Wilmington, DEN746MAPacific Aircraft Services LLC · Saint Helens, ORN747EMSal Holdings LLC · Helena, MTN7501EFranklin Dirk W · Beaumont, TXN750CAQualitair LLC Trustee · MichchelstadtN751BRPonderosa Aviation LLC · Safford, AZN751TRCareer Aviation Company Inc · Wilmington, DEN752ASierra Aeronautics LLC · Franklin, KYN753AKDh Leasing LLC · Juneau, AKN753KPKalinin Partners LLC · Juneau, AKN753TRCareer Aviation Co Inc · Wilmington, DEN758RFSck Express LLC · Englewood, CON758XPParaclete Aviation LLC · Raeford, NCN75MXNational Test Pilot School · Mojave, CAN760BFHeritage Ag LLC · Lakeview, MIN762JC21 Luna LLC · Phoenix, AZN762VM5-T Aviation LLC · Eunice, LAN763LDBadil-Abish Thomasena · Spring, TXN769KLCbg LLC · Wilsonville, ORN76WAFlying A Flight Service LLC · Safford, AZN770ABAgb Management Inc · Warrenton, VAN770TRCareer Aviation Co · Wilmington, DEN771FFChandler Energy LLC · Denver, CON773CCGlenn Air Inc · Palmer, AKN777LPGrace On Wings Inc · Indianapolis, INN777WMPower Alan · Los Alamos, NM
Back to AD 2011-18-51 R1