AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N1884MMontgomery Aviation LLC · Zionsville, INN18858Martindale Ian C · Seattle, WAN18859Molnair LLC · Columbus, GAN18861Phillips Gary O · San Rafael, CAN18862Koenig Michael · Mooresville, NCN18864Burnett Robert J · Garden Valley, CAN18865Shoreline Aviation LLC · Norman, OKN18867Wisniewski Joseph B · Ormond Beach, FLN18874Registration Pending · Pantego, NCRegistration pendingN1887SCavort LLC · New York City, NYN18887Clifford Royce Ellen · Leucadia, CAN1888EChoe Young Kyu · Manhasset, NYN18895Jmetic Consulting LLC · Springs, TXN188ABSafford Aviation Service Inc · Coolidge, AZN188AGRvest Management LLC · Boulder City, NVN188AHAlf Ix LLC · Chicago, ILN188BBBoening Bros Dairy Inc · Floresville, TXN188BCWaldron Elijah L · Murfreesboro, TNN188CCPlatt Aaron Eugene · Heppner, ORN188DHDunworth Jack R · Rutledge, GAN188DSCopper River Airmotive LLC · Copper Center, AKN188FMach 25 Aviation LLC · Hudson, WIN188GHAer Lightfoot LLC · Alpena, MIN188GTI&F LLC · Overland Park, KSN188HLFord Peter Scott · Tucson, AZN188JPMark Aero LLC · League City, TXN188LAAvf Flyers LLC · Richmond, VAN188LFBraund Matthew G · Albuquerque, NMN188MESenior Mi LLC · Batavia, ILN188PLe Duc Richard Steven · Mazama, WAN188PSBlackbird Jet LLC · Boca Raton, FLN188RACook Gary Lee · Ontario, CAN188RSVardaman Charles · Little Rock, ARN188SEChernov Boris · Lima, OHN188SMMehrhoff Stanley E · Prairie Home, MON188SPThornado Aviation LLC · Indialantic, FLN188TBGreenley William C · Dowagiac, MIN188WBNelson Pete L · Challis, IDN18909Thomas William Tyler · Athens, TNN18918Edc Aviation LLC · Middletown, RIN18920N18920 LLC · North Canton, OHN18924Swanson Jackson Van Dorn · Gustavus, AKN18928Kokkinos Antonios H · Naples, FLN18929Vector Aviation LLC · Mentor, OHN18930Trustgroup Aircraft Hangar Sales LLC · Metairie, LAN18934Gray Van D · Woodway, TXN18938Hangar 5 LLC · Williamsburg, VAN1893ALone Star Helicopter Inc · Lago Vista, TXN1893SSylvester Donald W · Santa Maria, CAN18940Mella Aviation LLC · Tucson, AZ
Back to AD 2006-10-21