AD 2003-26-06
Registered aircraft · 1,564
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:2003-26-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-26-06')
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:2003-26-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-26-06') 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.
N12FQN12fq LLC · Helena, MTN12MAForest Hill Management LLC · Forest Hill, MDN12NNAviation Trust Company LLC Trustee · Oklahoma City, OKN12WZNortech Data Services Inc · Wilmington, DEN12YJTiny Bubbles Aviation Inc · Pacoima, CAN130TMBurton Equity Management LLC · Arlington, VAN132Savauge Tbm LLC · North Las Vegas, NVN134TVNexstar Broadcasting Inc · Albuquerque, NMN135DDEuroaviation Inc Trustee · KematenN135MCWings Up IV LLC · Allen Park, MIN138JMFull Throttle Aviation LLC · Clayton, DEN138MAMainstream Aviation II LLC · Benton, KYN138RJBayou Flight Training LLC · Niceville, FLN141THTemsco Helicopters Inc · Ketchikan, AKN1421ZMng Leasing LLC · Bottineau, NDN143GKN143gk LLC · Sheridan, WYN144JTFlight 1976 LLC · Kennesaw, GAN145KKato Aviation LLC · Henderson, MNN145RKFowler Aviation LLC · Union, NJN145THTemsco Helicopters Inc · Ketchikan, AKN146MWMehling Kevin E · WiesbadenN147THTemsco Helicopters Inc · Ketchikan, AKN148JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN148THTemsco Helicopters Inc · Ketchikan, AKN148UMUnverferth Manufacturing Co Inc · Kalida, OHN149THTemsco Helicopters Inc · Ketchikan, AKN14EE14ee Corp · Cranberry Township, PAN14NXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN14SCSouth Central Aviation LLC · Evansville, INN150STMiles Donald C · Columbia, MON151AMacnealy Gregory A · Vandalia, OHN152RMBank Of Utah Trustee · Salt Lake City, UTN1569CN1569c Inc Trustee · Wilmington, DEN159DMLe Kenneth · Henderson, NVN15NMNorthern Valley Air Ltd LLC · Long Island, KSN15SBHgx Aviation LLC · West Chester, PAN160RMLjwms Partners Inc Trustee · Wilmington, DEN160TMTbm N160tm LLC · Fresno, CAN1625LArtime Jorge Daniel · Miami Beach, FLN165GTMckeon Aviation Leasing-N165gt LLC · Wilmington, DEN166GTRobinson David S Jr · King William, VAN168CWXu Zhaohui Executor · Memphis, TNFirst renewal noticeN168GTN168gt LLC · Newbury Park, CAN1711SAircraft Guaranty Corp Trustee · Oklahoma City, OKN171MVLittmarck Svante · Dedham, MAN173TMEllegeegee Corp · Northampton, MAN175JCSacramento County Sheriffs Office · Mather, CAN175KCKinzler Aviation LLC · Ankeny, IAN179NCSky Works LLC · Camarillo, CAN17YGTbmyan Inc Trustee · Wilmington, DE
Back to AD 2003-26-06