AD 2000-08-22
Registered aircraft · 433
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:2000-08-22')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-08-22')
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:2000-08-22') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-08-22') 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.
N502HPHonolulu Police Department · Honolulu, HIN502MMWinco Inc · Aurora, ORN502SLSc Law Enforcement Division · Columbia, SCN504EFAirwest Helicopters Inc · Redlands, CAN504SLSouth Carolina Law Enforcement Division · Columbia, SCN5063GCedar Helicopters LLC · Shelton, WAN506MPCity Of Mesa · Mesa, AZN50713Hlh Leasing LLC · Wilmington, DEN5072FWinco Inc · Aurora, ORN5074LHigh Life Helicopters LLC · Kalispell, MTN507CCRotorworks LLC · Hiram, GAN507HWHeliwild Investments LLC · Austin, TXN507TVShoreline Aircraft Leasing LLC · Lewes, DEN508PHApex Heli-Support LLC · Phoenix, AZN50APBank Of Utah Trustee · Salt Lake City, UTN50QDNorth Fork Helicopters Ltd · Cutchogue, NYN50XBRwb 66 LLC · Victoria, TXN5106YSouthern Aircraft Consultancy Inc Trustee · Casper, WYN5108ECorporate Leasing Services LLC · Helena, MTN510PACedar Helicopters LLC · Shelton, WAN510PDCity Of Oakland · Oakland, CAN510PJMid Pacific Aero Services LLC · Honolulu, HIN511SHHawkeye Helicopter LLC · Lyndon, KSN511VAAb Monterrey Aircraft LLC · Newark, DEN5125QTemsco Helicopters Inc · Ketchikan, AKN5129NEichner Eric D · Ketchikan, AKN512PJMid Pacific Aero Services LLC · Honolulu, HIN5132YEmaero LLC · Sequim, WAN5133UTemsco Helicopters Inc · Ketchikan, AKN5134VTemsco Helicopters Inc · Ketchikan, AKN513HTHeliservice LLC · Wilmington, DEN513PJMid Pacific Aero Services LLC · Honolulu, HIN514PAAa Leasing Lp · Kilauea, HIN515THRick'S Custom Fencing And Decking Inc · Hillsboro, ORN516BRichey Bradly L · Chico, TXN516PJSchreindl Lawrence A · Colton, ORN518PAPatriot Aviation Inc · Greenville, DEN519PAPatriot Aviation Inc · Greenville, DEN51MNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN5200WEmerald City Aircraft Leasing Inc · Port Orchard, WAN520ANHeliservices LLC · Wilmington, DEN520APLn095 1vc Trustee · Wilmington, DEN520EALn062 Inc Trustee · Wilmington, DEN520HSHfn Investments LLC · Birmingham, ALN520KYAltadena LLC · Birmingham, ALN520MDChatham County Mosquito Control · Savannah, GAN520MGHagedorn Aviation · Columbus, OHN520MHSilver Cloud One LLC · Reno, NVN520NQuantumtrace Inc · Incline Village, NVN520NMWillard Development Inc · Port Saint Lucie, FL
Back to AD 2000-08-22