AD 2022-08-13
Registered aircraft · 3,069
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:2022-08-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:2022-08-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:2022-08-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:2022-08-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.
N186DCAir Care Inc · Lamar, CON186PSRricko LLC · Portland, ORN186SGFeet Wet Aviation LLC · Scottsdale, AZN187GCZuni LLC · Kirkland, WAN187JDMacarthur Dougald F · Littleton, NHN187LALocker Fred · Muleshoe, TXN187MRJcs Air LLC · Auburn, ALN188CECruise Air LLC · Wilmington, DEN188DFArc Holdings LLC · Grand Junction, IAN188GCZuni LLC · Kirkland, WAN189PBBerryhill Aviation LLC · Atoka, TNN18AFN220pb LLC · Mesa, AZN18BTT5 Capital Partners LLC · Dallas, TXN18CMEdgewater Aviation LLC · Guntersville, ALFirst renewal noticeN18DSN18ds LLC · Mcminnville, ORN18KDH & W Ag Services Inc · Veribest, TXN18NRWonderful Pistachios & Almonds LLC · Lost Hills, CAN18NTYr-Aircraft Leasing LLC · Bethel, AKN18SFD&D Maintenance LLC · Etna Green, INN18SRW4 Air LLC · Willis, TXN190JPClearwater Midstream LLC · Lubbock, TXN190KMMec International Trading LLC · Mission, TXN190NCCf Holdings LLC · Hernando, MSN190WAAmeriflight LLC · Dallas, TXN191AVUas Transervices Inc · Boca Raton, FLN191AWCsi 135 Division LLC · Albuquerque, NMN191CSTvpx Ars Inc Trustee · North Salt Lake, UTN191DBMeridian Logistics LLC · Forest Lake, MNN191JRLocke-Lane Aviation LLC · Statesville, NCN191WAAmeriflight LLC · Dallas, TXN1927SBlue Sky Assets LLC · Garden Valley, IDN1928S1928 LLC · Salmon, IDN192GCMonarch Enterprises Inc · Kirkland, WAN192KQShort Field Partners LLC · Bend, ORN193KQAmerican O-Zones LLC · Tavernier, FLN193SUUas Transervices Inc · Boca Raton, FLN194CSNortheast Montana Stat Air Ambulance Cooperative · Glasgow, MTN194GAAlpine Aviation Inc · Provo, UTN195AAAir Travel Management LLC · Lemont Furnace, PAN195ALJmds Lift LLC · Helena, MTFirst renewal noticeN195GLAlpine Aviation Inc · Provo, UTN1966GAir Services International Charters LLC · Fort Lauderdale, FLFirst renewal noticeN1967HTbm 700 LLC · Denair, CAN196GCZuni LLC · Kirkland, WAN196LALocker Fred · Muleshoe, TXN196PK3m Ag LLC · Beebe, ARN196SCChickasaw Transport LLC · Santa Rosa Beach, FLN197RKArg Aviation LLC · Lexa, ARN197SCCharlie Ninety Alpha LLC · Searcy, ARN197WAAmeriflight LLC · Dallas, TX
Back to AD 2022-08-13