AD 2012-05-09
Registered aircraft · 6,155
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-05-09')
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-05-09')
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-05-09') 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-05-09') 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.
N1041CHelzer Timothy · Tucson, AZN1041GN1041g LLC · Charlotte, NCN10422Jackson Benjamin Tillman · Rancho Mirage, CAN1043HValiair Limited Co Trustee · Casper, WYN1043ZJones Property Services Inc · Pelham, ALN1044VTigers Air Inc · Fairfax Station, VAN1045FOpc Consulting LLC · Hickory Corners, MIN1045XServaty Frank R · Canyon Lake, TXN10469Airscout LLC · Valdosta, GAN1046UMetzel Peyton S · Libertyville, ILN1047AHolt Sheet Metal Inc · Durango, CON1047LMcneill Philip · Reston, VAN1048DDumbravo Dustin C · Yorktown, VAN1049TRoberts Kevin C · Athens, GAN104PBMountain Flight LLC · Missoula, MTN1050BNine1on Industries LLC · Helena, MTN1050QCouch Kelly P · Elk Grove, CAN1051KMcclure Paul D · Birmingham, ALN1051YChristophersen Hunter · Fairway, KSN1053LKutzleb Michael K · Fernandina Beach, FLN1053UEricson Kurt A · Gulfport, FLN1054CCumberland Curtis · Union Bridge, MDN1054KBondy William G · Miami Beach, FLN1056TTierno Patrick Louis · Seaford, DEN105PAPeck John A Jr · Shady Shores, TXN1064UHenline Aircraft Sales LLC · Hickory, NCN1065NEmmons James W · Bay Minette, ALN1065SGiacobbe Francesco · Severna Park, MDN1065WCartwright Alexander Brooks · New Paris, INN1065XRobert C Ripley Mdpc · Nashville, TNN1066UBurgoyne Wallace Carr Jr · Spring, TXN1067FNorklun Matthew J · Wainscott, NYN1067GKmeck Joseph J · Erie, CON1067WGraham James M · Minneapolis, MNN1068AWest Texas Aviation LLC · San Angelo, TXN1068GCanopy Ministries Inc · Mountain City, TNN1068RG & H Aviation · Louisville, KYN1068XChapel Hill Flying Club Ind DBA · Sanford, NCN1069GWilliams Jack · Lake Havasu City, AZN106QIntegrity Aero LLC · Boerne, TXN106TNSecond Wind Enterprises LLC · Atlanta, GAN1070ZSky West Aviation Inc Trustee · Albuquerque, NMN10719Florida Independent Truck Repair Inc · Greeneville, TNN1071UCrowder Zachary · Merritt Island, FLN1071YBreaux John Jr · Minden, NVN10725N22154 Inc · Wilmington, DEN1072NStephens Donald G · Huntington Beach, CAFirst renewal noticeN1072YRyan Aaron · Wichita Falls, TXN1072ZCorbett Henry E · Salem, ORN1073GProfessional Flyers Corporation · Wilmington, DE
Back to AD 2012-05-09