AD 2023-17-13
Registered aircraft · 1,956
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:2023-17-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:2023-17-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:2023-17-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:2023-17-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.
N148BAMorledge-Hampton Scott · Billings, MTN148SRTansky Stanley S · Logan, OHN1494TSouthern Flyers Eaa Chapter 1494 Inc · Dandridge, TNN14EPBatterman Eric P · Princeton, NJN14PMVerzwyvelt Michael W · Twin Falls, IDN1507JSmith Charles L · La Marque, TXN150JLLengacher John · Cannelburg, INN150RTRt Aviation LLC · Laurel, MSN151SGGurevich Alan · Seattle, WAN152BABank Of Utah Trustee · Salt Lake City, UTN152GHatfield Keith A · Dallas, TXN152RXPhelps Rex D · Macomb, MIN152SGSuedla Holding LLC · Wilmington, DEN152TUCampbell Steven G · Newport Beach, CAN152WPCook Christopher M · Twin Falls, IDN1538ZAno Build One · Plattsmouth, NEN153WPFlamingo Aviation LLC · Bend, ORN154RMurphys Auto Gyro Sales LLC · Dade City, FLN155BADhv Aviation LLC · Haverhill, FLN155MLawton John Mann · Whitwell, TNN15629Williams Donald B · Wingate, NCN1564Stick & Rudder LLC · London, KYN156BAUltralight Sport Aviation LLC · Union, MIN156TXDucote Kendall J · Prairieville, LAN156WSDryden Everett R · Wolcott, VTN157KSMulvey Airplanes LLC · Lockport, NYN158BASouthern Aircraft Consultancy Inc Trustee · Casper, WYN158MBKropelin Barry R · Waxhaw, NCN159BAMichellcona5 LLC · Brooklyn, NYN161BAPrecocity Academy LLC · Gibsonia, PAN161RNWaterwings Seaplanes LLC · Hoover, ALN162BAAtec Aviation LLC · Jupiter, FLN1632AUmatilla Rv LLC · Umatilla, FLN163BLHenry Steven T · Auburn, NHN164XStetson Jeffry W · East Lansing, MIFirst renewal noticeN164YSling Rental Aviation · Laguna Beach, CAN165CBSky West Aviation Inc Trustee · Albuquerque, NMN166KWalker Troy L · Greenville, ILN166KMKc Mead Bristell LLC · Brownsville, WIN1672LPike Phillip M · Saint Petersburg, FLFirst renewal noticeN167BLSport Flying USA Inc · Remsenburg, NYN167TUHawkins Flight Academy LLC · Shelbyville, TNN1682WDavis Chad A · Luana, IAN1688BChen Chris · Monrovia, CAN168DADynasty Aviation Inc · Pembroke Pines, FLN168MBNemec David M · Helendale, CAN168TWShin Richard C · Torrance, CAN16BAOwen Aviation Co LLC · Meridian, MSN16BMWilson Joshua A · Mckinney, TXN16ENDeland Air And Sea Brokerage Inc · Deland, FL
Back to AD 2023-17-13