AD 2011-05-08
Registered aircraft · 182
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:2011-05-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:2011-05-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:2011-05-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:2011-05-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.
N484LFGeisinger Medical Center · Danville, PAN485ECPitt County Memorial Hospital Inc · Greenville, NCN485LFGeisinger Medical Center · Danville, PAN486LF7513 Helicopter Inc Trustee · Wilmington, DEN487LFGeisinger Medical Center · Danville, PAN488LFSt Lukes University Health Network · Danville, PAN48SEPhi Health LLC · Tempe, AZN490HCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN491HCBank Of Utah Trustee · Salt Lake City, UTN492HCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN498AEPhi Health LLC · Tempe, AZN507MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN509CHChildrens Hospital Colorado · Aurora, CON522MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN523ECPitt County Memorial Hospital Inc · Greenville, NCN529MDFlight For Life Inc · Waukesha, WIN542AEAirbus Helicopters Inc · Grand Prairie, TXN545DUMetro Aviation Inc · Shreveport, LAN545KFAir Methods LLC · Greenwood Village, CON548GBAviation Instrument Services Inc · Miami, FLN575LFWest Penn Allegheny Foundation LLC · Pittsburgh, PAN576VPN576vp LLC · Chino, CAN578AMAir Methods LLC · Greenwood Village, CON585AEPhi Health LLC · Tempe, AZN585CHAir Methods LLC · Greenwood Village, CON590AEPhi Health LLC · Tempe, AZN592ACMetro Aviation Inc · Shreveport, LAN602MMTrustees Of The University Of Pennsylvania · Philadelphia, PAN608UWMetro Aviation Inc · Shreveport, LAN611SJAspirus Wausau Hospital Inc DBA · Wausau, WIN618GLGundersen Lutheran Medical Center Inc · La Crosse, WIN61UPTrustees Of The University Of Pennsylvania · Philadelphia, PAN624ECPitt County Memorial Hospital Inc · Greenville, NCN635TJAir Methods LLC · Greenwood Village, CON644LHBank Of Utah Trustee · Salt Lake City, UTN648BHFlight For Life Inc · Waukesha, WIN653LHBank Of Utah Trustee · Salt Lake City, UTN676LFWest Penn Allegheny Foundation LLC · Pittsburgh, PAN6UXHelicopters Inc · Cahokia, ILN745TXMother Frances Hospital Regional Health Care Ctr · Tempe, AZN759BHAir Methods LLC · Greenwood Village, CON770WSMetro Aviation Inc · Shreveport, LAN779LFAir Methods LLC · Greenwood Village, CON78NCAir Methods LLC · Greenwood Village, CON804PAPathfinder Leasing LLC · Anchorage, AKN814LVAir Methods LLC · Greenwood Village, CON816ECPitt County Memorial Hospital · Greenville, NCN824EHMetro Aviation Inc · Shreveport, LAN84UCUc Health LLC · Cincinnati, OHN850UWMetro Aviation Inc · Shreveport, LA
Back to AD 2011-05-08