AD 2002-01-31
Registered aircraft · 385
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:2002-01-31')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-01-31')
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:2002-01-31') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-01-31') 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.
N777SFUsda Forest Service Fepp · Minden, NVN78NWInternational Air Services Inc Trustee · Carson City, NVN790RJKing County Sheriffs Office · Seattle, WAN791CFHagglund Carl D · Pendleton, ORN794CFAlabama Center Of Military History · Huntsville, ALN795CFAlabama Center Of Military History (Acmh) · Huntsville, ALN79NWCbft LLC · Mobile, ALN8017GAgriforrestal Applications Inc · Arcadia, FLN803UHAmerican Huey 369 Inc · Peru, INN8043ZMagnum Aviation LLC · Goff, KSN8053TCoastal Helicopters Inc · Panama City, FLN8053YCoastal Helicopters Inc · Panama City, FLN806SBScotts Helicopter Service · Le Sueur, MNN80780Gagnon Roger M · Redding, CAFirst renewal noticeN8079EGagnon Roger M · Redding, CAFirst renewal noticeN80JGJimmy Graham Foundation Inc · Miami, FLN80NHMccarty David · La Grande, ORN81217US Dept Of State Inl/A · Melbourne, FLN8122NUS Dept Of State Inl/A · Melbourne, FLN812SBCavanaugh Air LLC · Addison, TXN815SCSnohomish County Sheriffs Office · Snohomish, WAN82121US Dept Of State Inl/A · Melbourne, FLN823LWLiberty War Bird Inc · Lititz, PAN8240XUS Department Of State · Melbourne, FLN82419US Department Of State · Melbourne, FLN827STMi State Police Field Supp Aviation · Lansing, MIN832DHSkyhop LLC · Santa Rosa, CAN832MStarks Daniel · Dubois, WYN841FCsw LLC · Anacoco, LAN841MRock Creek Leasing LLC · Sapulpa, OKN850MJones Aviation · Biggs, CAN851TPIkarus Aviation LLC · Salt Lake City, UTN854MJones Aviation Inc · Biggs, CAN857SDRegistration Pending · Anchorage, AKRegistration pendingN858MPacific Valley Aviation Inc · Arbuckle, CAN874High Performance Helicopters Corp · Crestline, CAN876EMNorthwest Helicopters LLC · Olympia, WAN876GMNorthwest Helicopters LLC · Olympia, WAN88976R Consulting & Sales Inc · Carson City, NVN88992Premier Aircraft Services LLC · Bakersfield, CAN891PMPorter Flying Service Inc · Chico, CAN892PMPm Dusters · Durham, CAN893PMPorter Flying Service · Durham, CAN902HEDown East Emergency Medicine Institute · Orono, MEN90760Advanced Aviation Technology Enterprises Inc · Arcadia, FLN910KCKnox County Sheriffs Office · Knoxville, TNN911BVJones Aviation Inc · Biggs, CAN911CECoastal Air Service Inc · Panama City, FLN911GCSacramento County Sheriffs Department · Mather, CAN911JMEmu Inc · Redwood City, CA
Back to AD 2002-01-31