AD 75-09-08
Registered aircraft · 3,035
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:75-09-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-08')
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:75-09-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-08') 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.
N124JKLewis Fred · Houston, TXN1251XStephens Donald W · Social Circle, GAN1255XThomas Russell Robert · Alhambra, CAN1257XGoodman Archie · Mart, TXN1258XCompton Nathaniel Brandon · Fredericksburg, VAN1259XSpencer H Brandon · Tampa, FLN1260XCross Paul D · Cowan, TNN1262XHawley Christopher M · Chandler, AZN1264XAnderson Kyle S · Portland, ORN1270XFox Aviation Holdings LLC · Leesburg, INN1272XUrban Norman A · Ray, MIN1277XDuke City Mooney LLC · Lakewood, CON1279XRegistered aircraftN1280XErlandson Michael D · Salt Lake City, UTN1289XConner James B · Mishawaka, INN128ESturges John A · Hayden, IDN128PBHayes Thomas G · Kerrville, TXN1290XJr Aviation LLC · Benton, KSN1292XBurns Barry D · Amarillo, TXN1294XMcglynn Brian · Friday Harbor, WAN1295XOz Aviation Inc · Cottonwood Falls, KSN1296XFox Judy · Ridgefield, WAN1297XScott Benjamin D · Grove City, OHN1299XMunoz David · Corona, CAN12YKinslow Eugene C Jr · Prospect, KYN1300AMann Lee S · Euless, TXN1303WPowell Steven J · Fairview, TXN1304WBrihn Rhonda J · Waterford, WIN1306W06 Whiskey Partners · Centennial, CON1309WSanford Mark J · Ithaca, NYN130LAInternational Air Services Inc Trustee · Carson City, NVN1312WKing Scott W · Tampa, FLN1314WNeches Air Inc · Silsbee, TXN1316WKurek Daniel L · Garden City, UTN1317WMorgenfeld Thomas A · Camarillo, CAN1320WBas Part Sales LLC · Greeley, CON1324WKcantarano LLC · Mukilteo, WAN1327WHexom Nathan R · Bozeman, MTN1329WKasowski Frank Jr · Becker, MNN1330WPepke Mark · Memphis, TNN1332WRegistered aircraftN1333WJamieson Robert A · Titusville, FLN1334WTwo Way Communications LLC · Graham, TXN1335WCastanon Salvador L · Rancho Cucamonga, CAN1336WThree Six Whiskey LLC · Billings, MTN1337WTriple Tree Aerodrome Inc · Woodruff, SCN1339W39 Whiskey LLC · Clovis, NMN133CLDukes Grant M · Horseshoe Bay, TXN1340WJohnson Jon · El Paso, TXN1343WInfinity Aviation LLC · Piedmont, SD
Back to AD 75-09-08