AD 2012-10-13
Registered aircraft · 13,306
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-10-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:2012-10-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:2012-10-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:2012-10-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.
N337TMFowler James Md · Mcallen, TXN338CPQualitair LLC Trustee · MichelstadtN338D38 Delta Corp · Killington, VTN338DKUp Top Aviation LLC · Piedmont, CAN338TXBussin' Air LLC · San Antonio, TXN33958Yoalz Inc Trustee · Wilmington, DEN339APParalos Aviation LLC · Penngrove, CAN339CDMcwethy22 LLC · Woodstock, GAN339DGRegistered aircraftN339DTGuzauff LLC · Katy, TXN339MCWilbers Aviation LLC · Austin, TXN339TMSoter Leasing LLC · Kalispell, MTN339TSCapstone Aviation LLC · Siloam Springs, ARN339WMFlying Frenchies LLC · Naples, FLN339WSGolf Stream Aviation LLC · Mattoon, ILN33ADSouthern Turf Services LLC · West Palm Beach, FLN33BBHendricks Timothy J · Telluride, CON33CFObx Boil Aviation LLC · Kitty Hawk, NCN33GXSiman-Tov Yariv · Redmond, WAN33HCSmith Christopher J · Longwood, FLN33HLKnudsen Russell G · East Troy, WIN33JGCavu 1989 LLC · New Hope, PAN33KBRegistered aircraftN33KKMcguiness Construction Inc · Ramona, CAN33KXEasy Peasy Aviation LLC · Ava, MON33LFJbo Airventures LLC · Saint Petersburg, FLN33MHAkeyson Edward W · Durham, CTN33MWSackett Gary G · Millcreek, UTN33PFNeed For Speed Aviation LLC · Charleston, SCN33PMKenmore Crew Leasing Inc Trustee · Bellingham, WAN33RHSteel Miles · Houston, TXN33RJRomeo Juliet Explorations LLC · Dover, DEN33SGMennella James E · Oklahoma City, OKN33SHDrl Baron LLC · San Augustine, TXN33TVTgbde LLC · Fort Pierce, FLN33UT402wd Holdings LLC · Corpus Christi, TXN33VKEaa Aviation Foundation Inc · Oshkosh, WIN33WKSager Earl Dwayne · Perryton, TXN33WRWilson Aviation LLC · Addison, PAFirst renewal noticeN33WSJak2 Properties LLC · Ocala, FLN33WVInarayan Inc · Winter Park, FLN33ZGK&A Heel Hawk LLC · Camden, DEN3404Renair LLC · Winter Garden, FLN3405QHardin David A · Tukwila, WAN3407CK&L Leasing And Investment LLC · Mountain Green, UTN340ABBison Investment Advisors Inc · Lafayette, INN340ADN89vy LLC · Benson, NCN340AGRicker David · Conway, ARN340AHEden On Broad LLC · Cookeville, TNN340AJListo Aviation LLC · Chelsea, AL
Back to AD 2012-10-13