AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N943TADe Peyster Francis V · Canby, ORN943TEZbikowski Scott · Lino Lakes, MNN943THSpirit Aviation Management Services Inc · Thomson, GAN943TTCkz Ventures LLC · Anchorage, AKN94400Macinnis James Michael · Copley, OHN94401Maui Aviators LLC · Pukalani, HIN94405Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN9440FPatton Phillip F · Gold Hill, NCN9440JDeascentis Dean · Lincoln, CAN9440LLuedemann Douglas S · Brenham, TXN9440NEshowe Aviation Inc · East Peoria, ILN9440VVanhorn Jonathan F · Laguna Hills, CAN9440WLicausi Dan · Cathedral City, CAN9441VKarge Robert F · Peachtree City, GAN9441WBaker Carl · Angleton, TXN9441ZTjb Capital LLC · Nashville, TNN9442Winger Aviation LLC · Palatine, ILN94429Wisconsin Aviation Inc · Watertown, WIN9442FRhodes Terry G · Snohomish, WAN9442NClear2aviate LLC · Ionia, MIN9442P42papa LLC · Soldotna, AKN9442RPauly Jeff D · Watkins, MNN9442VFlight Operations Academy LLC · Prescott, AZN94435Gibler Robert R · Peachtree City, GAN9443HAllport Bruce E · North Hollywood, CAN9443NSchulz John B Jr · Marquette, MIN9443WC H Draw Co Inc · Park City, KSN94447Flightime LLC · Stuyvesant, NYN9444DHurlbert Michael · Wasilla, AKN9444HPrestige Worldwide Aerospace LLC · Panama City, FLN9444LDiller Aaron J · La Salle, CON9444WMacedo Carlos C · Dayton, OHN9445DTriple Fes LLC · San Antonio, TXN9445HBrown Max K · Cushing, OKN9445JRamey Austin B · Salida, CAN9445KAishvaryam LLC DBA · Lancaster, TXN9445WEnglund Gary · Goldendale, WAN94461Daytona Aircraft Leasing LLC · Daytona Beach, FLN9446JFitch Stephen C · Moreno Valley, CAN9446LDiegoli John E · Ashland, ALN9447HLang Julia A · Greensburg, PAN9447LAirplane And Drone Flight Instruction LLC · Orlando, FLN9447NEvans Jeff W · Hannibal, MON9447WZiemann Mark · Camp Verde, AZN9448AOlson Ben A · Gig Harbor, WAN9448DLinear Farming Inc · Pleasant Grove, CAN9448JRichmond Heights LLC · Pocahontas, ARN9448LCole Douglas W · Kennewick, WAN9448NMason Harold R · Quincy, WAN9448PMgh Inc · Aurora, NE
Back to AD 81-18-04 R2