AD 75-23-07
Registered aircraft · 827
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-23-07')
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-23-07')
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-23-07') 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-23-07') 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.
N310UKInternational Air Services Inc Trustee · Carson City, NVN310VGGtc Services LLC · Ocala, FLN310VRWg Aircraft Holding Corp · Daytona Beach, FLN310VVMsl Air Inc · Sugar Grove, ILN310WDHernandez Jr Raymond Trustee · Burleson, TXN310WGMunro Donald W · Commerce Township, MIN310WHLexington Air Services LLC · Greenwood, MSN310WJAg N310wj LLC · South Salt Lake, UTN310WSN310ws LLC · Athens, ALN310WVHill Rick A · Bridgeport, WVN310XRValiair Limited Co Trustee · Casper, WYN310ZFlyin' Dog Air LLC · Niceville, FLN311RWWashburn Harrill Gene Jr · Rutherfordton, NCN311SKDoyle Thomas Michael · New City, NYN312CSFlybuys3 LLC · Lewes, DEN313JHJam Three LLC · St George, UTN314BBMarc Inc · Bolton, MSN314HBMarc Inc · Bolton, MSN314UPro Aire Cargo & Consulting Inc · Oshkosh, WIN316RALeading Edge Flight Services Inc · Hampshire, ILN317TRRcs Aeronautical Inc · San Antonio, TXN318UTraffic Law LLC · Tampa, FLN3195MAspire Management Inc · New Castle, DEN31GKMartin Richard B · Corona Del Mar, CAN31KGMidwest Corporate Air Inc · Bellefontaine, OHN31PGPlacette Jim · Houston, TXN31YKJendair LLC · New York, NYN321DWJsj LLC · Wilmington, DEN3227ABoho LLC · Lewes, DEN326PTJt Aero LLC · Covington, GAN3279MValiair Limited Co Trustee · Casper, WYN3284MSonrise Aviation LLC · Portland, INN3288MClute Kenneth N · Las Vegas, NVN32TLJonesboro Cycle And Atv LLC · Bone, ARN3310DGrewe Mike · Lake In The Hills, ILN331LSTechnical Education Services Inc · Virginia Beach, VAN3321MMaxray Aviation LLC · Ashland, OHN3322XAllgood Michael K · Saint Augustine, FLN333ESRebus LLC · Andover, KSN3364LLopez Edwin · Germantown, TNN3376GLindsay Aviation Inc · West Seneca, NYN3397GPro Aire Cargo & Consulting Inc · Oshkosh, WIN3399QBaron Aviation Corporation · Broad Run, VAN33VTTjr Aviation LLC · Orefield, PAN340CHAircraft & Aviation Professional LLC · Coldwater, MIN3417GDemark Aviation Inc · Wilmington, DEN3418GOppermann William A · Derby, KSN344AHAdams Flying Service Inc · Rayville, LAN3458GAmerican Aircraft Sales LLC · Livermore, CAFirst renewal noticeN3463GBuckles Robert F · Boseman, MT
Back to AD 75-23-07