AD 79-01-01
Registered aircraft · 8,424
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:79-01-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:79-01-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:79-01-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:79-01-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.
N106GATactical Safety Training LLC · Dublin, GAN106KV3 Aviation LLC · Lexington, OKN106MBBaron Phoenix Aviation LLC · Newport, RIN106RHSouthern Bracing Systems Inc · Armuchee, GAN1070WHill Richard P · Jacksonville Beach, FLN1071TChambliss 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, OKN1080STacoma Management Inc · Martinsville, VAN1080WParks Robert Steven · Hayward, CAFirst renewal noticeN1081YWc LLC · Austin, TXN1083WAeolus Aircraft LLC · Seminole, OKN1088LLima Whiskey Ic LLC · Mertzon, TXN1089CRegistered aircraftN1089EAml Aviation LLC · Lexington, KYN1089WKucera Christopher T · King George, VAN108ALRj Flight LLC · Saint Petersburg, FLN108BABemidji Aviation Services Inc · Bemidji, MNN108EBAndrie Inc · Muskegon, MIN108JHInternational Air Services Inc Trustee · Carson City, NVN108JTPierobon Patricia · Port Orange, FLN108LMSkyvista Aviation LLC · Marysville, OHN108RKBarnard Brian D · Tallahassee, FLN1091GUnderwood Mold Co Inc · Woodstock, GAN1092WAmerican Aviation LLC · Waterville, MEN1092YCbg Properties LLC · Madison, MSN1093GLombard William E · Bellingham, WAN1094GOgan Michael J · Pierre, SDN1094WPolhemus Paul L Jr · Lodi, CAN1095ATychsen Scott E Trustee · Horse Shoe, NCN1097GAos Aviation LLC · Baton Rouge, LAN1097WFred Wacker Agency Inc · Miles City, MTN1097ZIndian Sky LLC · Bossier City, LAN1098WB & G Aviation LLC · Virginia Beach, VAN1099AFritz William · Franklin, PAN1099WTop Hand Inc · Laurel, MTN109AFD&D Aviation LLC · Weatherford, TXN109BABall Edward C II · Valley Center, CAN109CZN109cz LLC · Milwaukee, WIN109DWAero East USA LLC · Portage, INN109EADegiarde Robert P · New York, NY
Back to AD 79-01-01