AD 96-09-13
Registered aircraft · 772
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:96-09-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:96-09-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:96-09-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:96-09-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.
N31702Uas Transervices Inc · Boca Raton, FLN31703Uas Transervices Inc · Boca Raton, FLN31704Uas Transervices Inc · Boca Raton, FLN31705Uas Transervices Inc · Boca Raton, FLN318CBBrown Flight Properties LLC · Midland, TXN31FMKing Air Adventure LLC · Wilmington, DEN31TNLake Clark Air Inc · Port Alsworth, AKN323PXFehrs Aviation LLC · Seminole, TXN324SAAtlantic Air Services 71991 Inc · Largo, MDN3250VK & J Air Services Ltd · Midland, TXFirst renewal noticeN326CAAlpine Aviation Inc · Provo, UTN326KWBering Air Inc · Nome, AKN327LCNeptune Agricultural Group Inc · Vero Beach, FLN32LJCrocker LLC · Missoula, MTN330AFUas Transervices Inc · Boca Raton, FLN330AVUas Transervices Inc · Boca Raton, FLN331AFUas Transervices Inc · Boca Raton, FLN332JSSouth Coast Lumber LLC · Brookings, ORN332LCUc132 LLC · Dallas, TXFirst renewal noticeN333QTQ Flight LLC · Bernardsville, NJN338AFAmeriflight LLC · Dallas, TXN341WBAndrews Worldwide LLC · Amarillo, TXN346AFAmeriflight LLC · Dallas, TXN346BALwcr Transportation Inc · Minot, NDN347AFAmeriflight LLC · Dallas, TXN349ARAcademy Resources LLC · Taos, NMN34AKUas Transervices Inc · Boca Raton, FLN34LTPaper Boys LLC · Dover, DEN34RZUas Transervices Inc · Boca Raton, FLN351KBKabco Aviation LLC · Boaz, ALN351SAGuardian Flight LLC · Lewisville, TXN360EASai Flight Services Inc · Greer, SCN360XNavecord Institute · Wilmington, DEN361EAAlcyone Trust Corp Trustee · Wichita, KSN361TDSequoia Beverage Co Lp DBA · Visalia, CAN3620MSanford Medical Center · Sioux Falls, SDN363DFreeman Holdings Of West Texas LLC · Medford, ORN363JHBering Air Inc · Nome, AKN367SFSuburban Air Freight Inc · Omaha, NEN36987Westflight LLC · Yuma, AZN370CSReach Air Medical Services LLC · Santa Rosa, CAN375JPAir T-Jam LLC · Uniontown, PAN377JEAcr Advertising LLC · Jasper, INN378AWSkyline Aviation Services LLC · Miramar, FLN379EKAvtrust LLC Trustee · Wilmington, DEN380JPPaalmc Llv · Shreveport, LAN381HCIntermountain Medical Transport LLC · Salt Lake City, UTN383RLRescue 383 LLC · Annapolis, MDN38537Optimumedicine LLC · Las Vegas, NVN388AVUas Transervices Inc · Boca Raton, FL
Back to AD 96-09-13