AD 2012-06-01
Registered aircraft · 726
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:2012-06-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-06-01')
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:2012-06-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-06-01') 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.
N87NSSeaman Corporation · Wooster, OHN87WUBarristair Lc · Beaumont, TXN880POp Aviation LLC · Seattle, WAN881VPCitation Technology Partners LLC · Woodside, CAN883PFPrestage Farms Inc · Clinton, NCN883SCBuffalo Bayou Air LLC · Houston, TXN884BFriendly Skies 2 LLC · Muncie, INN885BHWest Star Construction Inc · Kingsburg, CAN887PCPcj LLC · Carmel, INN887WPPack Force One LLC · Raleigh, NCN888RTOrlando Plane Partners LLC · Orlando, FLN88AFRair LLC · Chicago, ILN88CSTelepak Networks Inc · Ridgeland, MSN88HPNlp Leasing LLC · North Adams, MAN890JSDtfa LLC · Kinston, NCN891JSRegistered aircraftN891SCIsc Aviation LLC · Baton Rouge, LAN892JSRegistered aircraftN892SBN318mm LLC · Topeka, KSN892ZZirkle Aviation LLC · Selah, WAN8JWWatkins Construction Company LLC · Corsicana, TXN900ADPnc Bank Na · Boise, IDN900KDThird Rockmar LLC · Denton, TXN900TVN900tx LLC · Austin, TXN900XLMonroe Aviation LLC · Columbus, MSN901CBBravo 997 LLC · Grand Rapids, MIN901CRCxlo Enterprises LLC · Cincinnati, OHN902FHCcbcc Operations LLC · Charlotte, NCN906ACBabs Air LLC · Georgetown, TXN906DKLangdale Industries Inc · Valdosta, GAN907WTCj Blue LLC · Little Rock, ARN909GCMw Air LLC · Lincoln, NEN90FDStonewall Aviation LLC · Oklahoma City, OKN913CLDp Leasing LLC · Gilford, NHN913TFTosh Farms · Henry, TNN915TMTomel Holdings LLC · Idalou, TXN916CSAvlease Company LLC · Ann Arbor, MIN916JRock Springs Management Inc · Great Bend, KSN918RZBank Of Utah Trustee · Salt Lake City, UTN921BRN921br LLC · Sulpher, OKN921CGOffshore Energy Service Inc · Broussard, LAN923GSGreat Southern Bank · Springfield, MON925BWCobblestone Aviation LLC · Neenah, WIN928CFBzt Consulting LLC · Scottsdale, AZN933MRMontana Aircraft Trust Inc Trustee · Bozeman, MTN935BBWells Enterprises Inc · Le Mars, IAN935PFPentagon Federal Credit Union · Mclean, VAN936EASeven Hills 5260 LLC · Lynchburg, VAN941KAKag Leasing Inc · North Canton, OHN952RBBest Advantage LLC · Kittitas, WA
Back to AD 2012-06-01