AD 2007-08-08
Registered aircraft · 12,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:2007-08-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-08-08')
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:2007-08-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-08-08') 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.
N1065BRegistered aircraftN1066HBaronhfl LLC · Jacksonville, FLN1066PG&K Management Co LLC · Ocala, FLN1069FRobinson Andrew · Wernersville, PAN1069WElk Lake Group Inc · Plymouth, MNN106BAnderson Martino G · Lakeland, FLN106GATactical Safety Training LLC · Dublin, GAN106KV3 Aviation LLC · Lexington, OKN106MBBaron Phoenix Aviation LLC · Newport, RIN106NChenevert Eric M · Clarence, NYN106VKenyon Joseph S · Fort Collins, CON1070WHill 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, ALN1077B85 Alpha Inc · Wilmington, DEN1077WPrewitt 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, KYN1080STacoma 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, VAN108BCaturia Jeffrey T · Layton, UTN108GBLooney Jordan · Trumann, ARN108JHInternational Air Services Inc Trustee · Carson City, NVN108JTPierobon Patricia · Port Orange, FLN108RKBarnard 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, LA
Back to AD 2007-08-08