AD 64-06-06
Registered aircraft · 4,741
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:64-06-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:64-06-06')
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:64-06-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:64-06-06') 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.
N1000PJames Bond Aviation LLC · Belgrade, MNN1009XEnders Richard A · San Bernardino, CAN100HRSouthern Aircraft Consultancy Inc Trustee · Casper, WYN100JEResearch Consultant Solutions LLC · Miami, FLN101YTJagt Terrence L · Crestline, CAN1023XBickley David R · Pocatello, IDN1034XBlasa Randy · Bowling Green, FLN103TTAero Dynamics Flying Club Inc · Mulino, ORN1041XGyllensten Scott · Guilford, CTN1057XWeisenberger Thomas · Norwalk, OHN1060TWindy Hill Farm LLC · Cochranville, PAN1067XArchey Richard L · Georgetown, KYN1072XDemaagd Ross E · Middleville, MIN1079YBoyer Jerry D · Monument, ORN1082XWhitmer Ronald N · Ellsworth, KSN109RBClark William R · Anchorage, AKN1102XMarak Enterprises LLC · Galena, MON1109XBruno Michael J · Pittsburg, CAN110TNMaloney Casey · Placerville, CAN1118ZMoorhouse Mark A · Santa Fe, TNN111NPBlackfoot Aviation LLC · Bozeman, MTN1123WThiel Jonathan Ronald · Billings, MTN1144XFly Texas Sky LLC · Arlington, TXN114CFAw Chartering LLC · Franklin, TNN1159XBarrett Tyler J · Cullman, ALN1168XJz Air LLC · Brooklyn, NYN1177XParrish View Farms · Kenbridge, VAN1178XN1178x LLC · Dover, DEN1184XLairson Samuel E III · Ocean City, NJN1185XWilliamson Flying Club Inc · Williamson, NYN1188TAbrams Jeffrey Scott · Phoenix, AZN1198XDiscover Aviation Center LLC · Elyria, OHN11GNHaley James M Trustee · Edmond, OKN11HAVintage Aero Inc · Brandon, FLN11KAlbers Edward C · Burlington Flats, NYN11LYBishop Jay K · Columbus, INN11NTSabb Anthony · Wetumpka, ALN1206TCps 1 LLC · Pelham, ALN1214TPost 8 Flight Opps Inc · Topeka, KSN1226TLinde Glenn F Jr · Juneau, WIN122HSMarbury Sherri E · Jackson, TNN1235SBarney Erick L · Jacksonville, ORN123GEFlying Four Inc · Saint Petersburg, FLN123SWBelschner Custom Meats · Amherst, NEN123TXGofly Corporation · Port Ewen, NYN1242TDoblmaier Thomas J · North Wales, PAN124JCDestination Aviation LLC · Destin, FLN1261TObrien Timothy D · Alplaus, NYN1270TTubman Wilbur C · Grand Rapids, MIN127MDCosbie Lee R · Tuscumbia, AL
Back to AD 64-06-06