AD 91-17-01
Registered aircraft · 8,282
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:91-17-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-17-01')
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:91-17-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-17-01') 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.
N103SMHermack John F · Toms River, NJN103WWWilkin Richard G · Monticello, ILN1040TTen Forty Tango LLC · Wichita, KSN1042RSale Reported · Los Angeles, CASale reportedN1042TJbr Leasing Inc · Orlando, FLN1043WLatitude Aviation LLC · Cedar Rapids, IAN1045WButler Richard S · Poplar Grove, ILN1047W1047w LLC · Oakland, TNN104FMEide Machinery Sales Inc · Minneapolis, MNN104LARegistered aircraftN104MMBaron 104mm LLC · Rohnert Park, CAN104WWJarosak Peter J · Valparaiso, INN1050TThrash Scott · Hesston, KSN1054WHeavers George S · Oakland, CAN10554T34sum LLC · Lake In The Hills, ILN1057WMaisano Abby · Hendersonville, TNN1058RWindle Air Baron LLC · Lynchburg, VAN105FADebbie Air LLC · Perkasie, PAN105RKEwing John M · Cumming, GAN1060RCooper Don F · Great Falls, VAN1060WHarvey Ara Jr · Hernando, MSN1061DCcr 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, MNN106GATactical Safety Training LLC · Dublin, GAN106KV3 Aviation LLC · Lexington, OKN106MBBaron Phoenix Aviation LLC · Newport, RIN1070WHill Richard P · Jacksonville Beach, FLN10712Hall Air Inc · Weiner, ARN1071TChambliss Aviation Services LLC · Greer, SCN1071WPcs 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 aircraftN107HMission Accomplished LLC · Boca Raton, FLN107JSSayers James B · Edison, OHN107LULynn University Inc · Boca Raton, FLN107MMBonanza Aviation LLC · Tulsa, OKN107VWHenning Nancy E · Hardinsburg, KY
Back to AD 91-17-01