AD 97-16-10
Registered aircraft · 7,447
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:97-16-10')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-16-10')
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:97-16-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-16-10') 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.
N103BABemidji Aviation Services Inc · Bemidji, MNN103EMSjm Aero LLC · Winter Haven, FLN103EYSouthern Aircraft Consultancy Inc Trustee · Casper, WYN103FSHannah Lonnie · Williamson, WVN103GLNaylor Aviation LLC · Columbia, MON103LHKavalair LLC Series D · Marion, MTN103RMValiair Lc Trustee · Casper, WYN103SEClear Prop Aviation LLC · Sioux City, IAN103SMHermack John F · Toms River, NJN1040WFoolish Pleasure Aviation Inc · Lewes, DEN1043WLatitude Aviation LLC · Cedar Rapids, IAN1044HWiebe Farms Inc · Hooker, OKN1044WAngier 66 LLC · Durham, NCN104FMEide Machinery Sales Inc · Minneapolis, MNN104JHDouble Helix Solutions LLC · Kamuela, HIN104LARegistered aircraftN104WPMartyn Christian A · Hallendale, FLN104WWJarosak Peter J · Valparaiso, INN1050TThrash Scott · Hesston, KSN1054WHeavers George S · Oakland, CAN1054XMurphy George E · Robinson, ILN1057WMaisano Abby · Hendersonville, TNN1058RWindle Air Baron LLC · Lynchburg, VAN1060RCooper Don F · Great Falls, VAN1061DCcr Aviation LLC · Summit, NJN1061FFoxtrot Flight LLC · Clarksdale, MSN1061WHollinshed Thomas O · Fayetteville, NCN1062WSale Reported · Douglas, GASale reportedN1063WDakota Land LLC · Simms, MTN1064CBayside Development LLC · Bellingham, WAN1065BRegistered aircraftN1066HBaronhfl LLC · Jacksonville, FLN1066PG&K Management Co LLC · Ocala, FLN1069FRobinson Andrew · Wernersville, PAN1069WElk Lake Group Inc · Plymouth, MNN106BABemidji Aviation Services Inc · Bemidji, MNN106GATactical Safety Training LLC · Dublin, GAN106KV3 Aviation LLC · Lexington, OKN106MBBaron Phoenix Aviation LLC · Newport, RIN1070WHill Richard P · Jacksonville Beach, FLN1070XMosby Group LLC · Edgerton, MON1071WPcs Air LLC · Middletown, PAN1072FGeorgia Air LLC · St Simons Island, GAN1073SAlabama Department Of Transportation · Montgomery, ALN1074WDreamweaver Aviation LLC · Citra, FLN1075XFisher Creek Corp · Grove Hill, ALN1077WPrewitt Russell · Statham, GAN1078SRegistered aircraftN107ABHobart Aviation Inc · Akron, OHN107LULynn University Inc · Boca Raton, FL
Back to AD 97-16-10